View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default 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