software

Hi

If I enter any number into a cell it divides it by 10, for example if I
enter 32 it displays it as 3.2.

I have tried closing down Excel and re-opening it, but this hasn't
solved it, but if I save the file to a disk and open it on another
machine it displays it correctly ie 32.

Anyone any ideas

Thanks in advance

Mossy--
Mossy
------------------------------------------------------------------------
Mossy's Profile: www.excelforum.com/member.php...oamp;userid=34654
View this thread: www.excelforum.com/showthread...hreadid=544210Hi Mossy,
Maybe you have Fixed Decimal places set to 1

If you go to Tools -gt; Options -gt; Edit you can un-check the Fixed
Decimal places

Regards,
Bondi
Bondi Wrote:
gt; Hi Mossy,
gt; Maybe you have Fixed Decimal places set to 1
gt;
gt; If you go to Tools -gt; Options -gt; Edit you can un-check the Fixed
gt; Decimal places
gt;
gt; Regards,
gt; Bondi

Bondi

Thank you so much, I would never have found that.

Much appreciated

Mossy--
Mossy
------------------------------------------------------------------------
Mossy's Profile: www.excelforum.com/member.php...oamp;userid=34654
View this thread: www.excelforum.com/showthread...hreadid=544210