How to correct the number format?
 

Numbers show 2,50 instead of 2.50 How to reset them?

How to correct the number format?
 

On Jan 19, 9:11*pm, Prateep wrote:
Numbers show 2,50 instead of 2.50 How to reset them?

Try clicking on ToolsOptionsInternational and work with the options
under Number Handling.

How to correct the number format?
 

Sat, 19 Jan 2008 21:11:00 -0800 from Prateep
:
Numbers show 2,50 instead of 2.50 How to reset them?

This is a matter of your language and regional settings.

Usually it is best to set these in Windows rather than Excel. In
Excel, Tools | Options | International and make sure that "use system
separators" is checked.

In Windows Control Panel, choose Regional and Language Options.
Select your language choice and you should see your desired
separators. If your language is correctly set but you want the
separators to be different, click Customize and change them.

You might need to close and reopen Excel, or even to restart Windows,
for this change to take effect.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/