Tools - Options...
Choose the Edit tab and clear the *Fixed Decimal* option


Steve


On Sat, 28 Oct 2006 09:17:02 +0100, Andy
wrote:

When I used to entre a number in my spread sheets as 120 it would read
120.
now it reads 1.2 and the same for any other numbers I enter. 150 is now
1.5
etc.
I cant understand how this has suddely changed. I've tried the format
options but I cant stop this happening. Any ideas please