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.

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.

<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.