Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Bug - Decimals in Excel Worksheet
On one particular machine, in Excel, any number typed into a worksheet is
automatically converted to a decimal (ie 10 changes to 0.1, 20 changes to 0.2). Have checked all formatting options and they are all OK, have tried deleting the blank template, and still the problem re-appears. Has anyone come across this before, could it be a small virus, or just another bug in the system. Any help is really appriciated. |
#2
|
|||
|
|||
Uncheck fixed decimal places under toolsoptionsedit
-- Regards, Peo Sjoblom "Ian" wrote in message ... On one particular machine, in Excel, any number typed into a worksheet is automatically converted to a decimal (ie 10 changes to 0.1, 20 changes to 0.2). Have checked all formatting options and they are all OK, have tried deleting the blank template, and still the problem re-appears. Has anyone come across this before, could it be a small virus, or just another bug in the system. Any help is really appriciated. |
#3
|
|||
|
|||
<Tools <Options <Edit tab,
And *Uncheck* "Fixed Decimal Places". -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Ian" wrote in message ... On one particular machine, in Excel, any number typed into a worksheet is automatically converted to a decimal (ie 10 changes to 0.1, 20 changes to 0.2). Have checked all formatting options and they are all OK, have tried deleting the blank template, and still the problem re-appears. Has anyone come across this before, could it be a small virus, or just another bug in the system. Any help is really appriciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
save an Excel worksheet as a comma delimited file? | Excel Discussion (Misc queries) | |||
how do I name ranges in an Excel worksheet | Excel Worksheet Functions |