Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to correct the number format?
Numbers show 2,50 instead of 2.50 How to reset them?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Picking correct number with < | Excel Discussion (Misc queries) | |||
date format not correct | Excel Discussion (Misc queries) | |||
How can I correct a custom format? | Excel Discussion (Misc queries) | |||
Correct Format for formula | Excel Worksheet Functions | |||
How do i format a 5 to 6 digit number into the correct date? | Excel Worksheet Functions |