Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Default Cell Format Problem
My numbers display as if they are all dived by 100; enter 555 display = 5.55.
How do I get back to a normal display? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Default Cell Format Problem
Chuck, Your problem is related to Fixed Decimal formatting.
If you are using Excel 2007, then please refer this link to understand and fix the problem: http://office.microsoft.com/en-us/ex...4991033.aspx#3 If you are using Excel 2003, then please use the following steps: [Tools] - [Options] - [Edit] tab. Turn off the [Fixed Decimals] option. Hope this helps, Kamlesh "Chuck G" wrote in message ... My numbers display as if they are all dived by 100; enter 555 display = 5.55. How do I get back to a normal display? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Default Cell Format Problem
Hi,
In 2003 choose Tools, Options, Edit and uncheck Fixed decimal In 2007 choose Office Button, Excel Options, Advanced, and uncheck Automatically insert a decimal point. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Chuck G" wrote: My numbers display as if they are all dived by 100; enter 555 display = 5.55. How do I get back to a normal display? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Default Cell Format Problem
Kamlesh,
Excellent! It worked. Thanks for the help. "Kamlesh Rao" wrote: Chuck, Your problem is related to Fixed Decimal formatting. If you are using Excel 2007, then please refer this link to understand and fix the problem: http://office.microsoft.com/en-us/ex...4991033.aspx#3 If you are using Excel 2003, then please use the following steps: [Tools] - [Options] - [Edit] tab. Turn off the [Fixed Decimals] option. Hope this helps, Kamlesh "Chuck G" wrote in message ... My numbers display as if they are all dived by 100; enter 555 display = 5.55. How do I get back to a normal display? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Default Cell Format Problem
Thats great Chuck. Kindly park this post entry as "Answered", so that it
will benefit others too :) Regards, Kamlesh "Chuck G" wrote: Kamlesh, Excellent! It worked. Thanks for the help. "Kamlesh Rao" wrote: Chuck, Your problem is related to Fixed Decimal formatting. If you are using Excel 2007, then please refer this link to understand and fix the problem: http://office.microsoft.com/en-us/ex...4991033.aspx#3 If you are using Excel 2003, then please use the following steps: [Tools] - [Options] - [Edit] tab. Turn off the [Fixed Decimals] option. Hope this helps, Kamlesh "Chuck G" wrote in message ... My numbers display as if they are all dived by 100; enter 555 display = 5.55. How do I get back to a normal display? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 Cell Format Problem | Setting up and Configuration of Excel | |||
Excel 2007 Default Cell Format | Excel Discussion (Misc queries) | |||
Default cell format in Excel | Excel Discussion (Misc queries) | |||
Excel default number format problem | Excel Discussion (Misc queries) | |||
Date format default problem | Excel Worksheet Functions |