How to correct the number format?

S

Stan Brown

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top