View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
 
Posts: 1,104
Default Excel Formatting Problem

Just a possibility - not sure if this is the problem:
Select a cell with the odd currency display
On the Home tab locate the Styles group and clink of Cell Styles
Right click on the Currency style and use Modify
Check the position of commas in the format
Let us know if this is a fix
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Pat" wrote in message
...
I am not new to Office 2007 but have encountered an error I can't figure
out.
My brother, who IS new to Excel, installed Office 2007 within the past six
months. He sent me a worksheet that he had been working on that showed
extra
commas in each of the cells, e.g., $4,00,550. When I open his file on my
computer, it doesn't show the extra comma. I had him try various formats
in
which commas are included, but it always comes up with the extra one.

I even sent him a very simple file with numbers such as $400,550.00. My
file
is accurate, but when he opens it at his end, he gets, $4,00,550.00.

Any suggestions?

Thank you.
--
Pat