Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007-digit separator ',' for numbers/currency exceeding 999,
I am unable to display numbers larger than 999,999 with the digits separator.
Excel displays numbers as 1000,000.00 rather than 1,000,000. Is there a problem with Excel 2007? www.panadigm.com |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007-digit separator ',' for numbers/currency exceeding 999,
Hi Keith
I have no problem. I just entered 1E+52 into a cell formatted as separate Thousands with commas and two decimal places and I get 10,000,000,000,000,000,000,000,000,000,000,000,000 ,000,000,000,000,000.00 I am using Vista 32 bit and XL2007 SP1 Check your Regional settings -- Regards Roger Govier "Keith" wrote in message ... I am unable to display numbers larger than 999,999 with the digits separator. Excel displays numbers as 1000,000.00 rather than 1,000,000. Is there a problem with Excel 2007? www.panadigm.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007-digit separator ',' for numbers/currency exceeding 999,
No this is not an Excel 2007 problem. Is it possible that your Windows
Regional Setting are set to use Indian currency format? Click a cell with the odd format; and then go into the Custom Format dialog to see what it is set to? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Keith" wrote in message ... I am unable to display numbers larger than 999,999 with the digits separator. Excel displays numbers as 1000,000.00 rather than 1,000,000. Is there a problem with Excel 2007? www.panadigm.com |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007-digit separator ',' for numbers/currency exceeding 999,
Thanks Roger. I changed the region to English( US) and the format now works
correctly. It was originally set to English (Trinidad ) and I believe there is a formatting problem there... But I am good to go... Thanks again... -- www.panadigm.com "Keith" wrote: I am unable to display numbers larger than 999,999 with the digits separator. Excel displays numbers as 1000,000.00 rather than 1,000,000. Is there a problem with Excel 2007? www.panadigm.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Digit Separator | Excel Worksheet Functions | |||
group (add) numbers without exceeding 168" the best possible way. | Excel Discussion (Misc queries) | |||
How do we add a separator in Excel 2007 menu using VBA | Excel Discussion (Misc queries) | |||
Comma separator for custom Currency | Excel Discussion (Misc queries) | |||
Comma separator for custom Currency (Indian Rupee) | Excel Discussion (Misc queries) |