Thread: Excel 2007-digit separator ',' for numbers/currency exceeding 999,
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
  
Posts: 1,104
Default 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


Reply With QuoteReply With Quote