Excel - Office 2007 Excel

I have Office 2007. How do I get my 1000 separator  in Excel to read
2,000,000 and not 2000,000?

  Roger Govier replied...

Hi Chuck

In Control Panel, go to Regional Settings and see what is set there.
Amend if it does not show the correct setting for your location.

--
Regards
Roger Govier

Win7 VirtualStore Weirdness with Excel 2002 and earlier Excel I thought I'd share a weird experience I had today in case it saves installer for it - - which registers it as an add-in for all installed versions of Excel - - and tested it. Fine in Windows 2000 in all installed versions of Excel. Boot to Windows XP, fine there too. Boot to Windows 7. Fine in Excel 2010, 2007, and 2003. But Excel 2002 and 2000 were still loading the old version of the add-in. I uninstalled the add-in, made sure it was gone, and reinstalled it. Same problem in Excel 2002 and earlier; still works fine in Excel 2003 and later. I opened the VB

Calculate actual trunk utilization based on call start / duration Excel I am 'attempting' to calculate our phone line utilization at work. The end goal is the more difficult it becomes. I have roughly 250, 000 calls (I'm obviously using excel 2007) that I am attempting to run calculations against. Here is a sampling of the data a way to determine how many lines we actually need. Good Luck and Thanks, Nathaniel Excel Programming Discussions Sheets (1) Excel (1) GetMaxUsageBySecond (1) SUMPRODUCT (1) INDIRECT (1) Macro (1) SUM (1) MAX (1) Let's Resource Utilization and many thick books have been written on the topic. You can use Excel with some simple formulas to get information about your data. Let’s say we split column C. I began in row #3. In D1 and D2 we enter: 3 / 19 / 2007 8:00:00 3 / 19 / 2007 8:01:00 the beginning and end of a typical one minute window. In D3

Experience with 2003 & 2007 on same computer? Excel I have Office / Excel 2003 on Win XP SP3. I would like to install (just) Excel 2007 (not Office 2007) on the same computer (standalone laptop). I have found a 2008 posting with a reference

Counting shifts lost between two dates Excel Hi Group, I'm working on a sickness monitoring sheet and I have four columns F$3+N("sick before start fit after end"), 0))))))) Shift lookup table 01 / 01 / 2007 1 02 / 01 / 2007 1 03 / 01 / 2007 1 04 / 01 / 2007 1 05 / 01 / 2007 06 / 01 / 2007 07 / 01 / 2007 08 / 01 / 2007 09 / 01 / 2007 1 10 / 01 / 2007 1 11 / 01 / 2007 1

problems at Excel 2007 loading Excel Hello, I just installed office 2007 enterprise, all works fine except that in Excel each time I start it and then starts to load the Euro Currency Tools add related to the Euro Currency Tools Add-in because when I unmark it on the Excel add-ins list so it won't load, Excel loads correctly. I think the problem has to do with that first I installed office