| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Value trouble!!!
Hello all,
Whenever I am adding any value to a cell, the value by itself gets divided by 100, that means if I am writing 1000, it shows the value of 10!!! And if I type 1000.0, then it shows the value 1000, I have checked the decimal points and everything seems to be ok!!! So, if I type 1234, it shows 12.34!!! Please help!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Value trouble!!!
Goto ToolsOptions and on the Edit tab there is a checkbox for Fixed
Decimal. Uncheck that box. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sim" wrote in message ... Hello all, Whenever I am adding any value to a cell, the value by itself gets divided by 100, that means if I am writing 1000, it shows the value of 10!!! And if I type 1000.0, then it shows the value 1000, I have checked the decimal points and everything seems to be ok!!! So, if I type 1234, it shows 12.34!!! Please help!!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Value trouble!!!
Wow!!!
Thankyou for your reply, I cd solve the problem, thankyou very very much!!! :) Sim "Bob Phillips" wrote: Goto ToolsOptions and on the Edit tab there is a checkbox for Fixed Decimal. Uncheck that box. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sim" wrote in message ... Hello all, Whenever I am adding any value to a cell, the value by itself gets divided by 100, that means if I am writing 1000, it shows the value of 10!!! And if I type 1000.0, then it shows the value 1000, I have checked the decimal points and everything seems to be ok!!! So, if I type 1234, it shows 12.34!!! Please help!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trouble with IF | Excel Worksheet Functions | |||
| dim trouble | Excel Discussion (Misc queries) | |||
| >= Trouble | Excel Discussion (Misc queries) | |||
| still having trouble with this.... | Excel Worksheet Functions | |||
| trouble with add ins | Excel Discussion (Misc queries) | |||
Linear Mode
