Excel Formatting Problem

[Pat]

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.

 

[Bernard Liengme]

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

 

[Gord Dibben]

I would have him check his Regional Settings in Control Panel.


Gord Dibben MS Excel MVP

 

[Pat]

This worked, Gord! Thank you . . . my brother had English (Hindi). We never,
in a million years, would have figured this out.

Thanks again,
Pat

 

[Pat]

Thank you for your response, Bernard. I had already tried this.

Pat

 

[Bill Sheridan]

Gord:
Pat is much smarter than me but I am much better looking! Thanks for the help.
Bill Sheridan...Des Moines, IA

 

[Gord Dibben]

Good to hear.

Thanks for the feedback.


Gord

 

[Bill Sheridan]

Gord:
I am Patrick's brother. He may be smarter than me...but I'm a heckuva' lot
better looking!!!

Thanks so much for your advice. It was spot on.

Bill Sheridan-Des Moines, IA