Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel automatically deviding value by 100...
Whenever i am enetering any number in excel it is automatically deviding it
by 100 like if I enter 2 then it will store as 0.002. Whenever I am having any formula calculation then there is no prblem .... Can anybody help me ??? Thanks a lot |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel automatically deviding value by 100...
Try this:
From the Excel Main Menu: <tools<options<edit tab UNcheck: Fixed Decimal Places Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Irfan Khan" wrote in message ... Whenever i am enetering any number in excel it is automatically deviding it by 100 like if I enter 2 then it will store as 0.002. Whenever I am having any formula calculation then there is no prblem .... Can anybody help me ??? Thanks a lot |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
deviding hours | Excel Discussion (Misc queries) | |||
Run PPS automatically in Excel? | Excel Discussion (Misc queries) | |||
Save excel automatically | Excel Discussion (Misc queries) | |||
Update Excel table in Word automatically from data in Excel | Excel Discussion (Misc queries) | |||
In Excel, have time of day appear automatically. | Excel Worksheet Functions |