Ah! I learn something new every day!


--
RyGuy


"David Biddulph" wrote:

Tools/ Options/ Edit
Uncheck: Fixed decimal places.
--
David Biddulph

wrote in message
...
In the last year, whenever I use Excel 2000 spreadsheet, I key in a
number [eg: 500 creates 5.00]. I have attempted to change the cell
format to 'General' without success. Changing to 'Number' brings the
same result except that the number is truncated [5]. This has become
very annoying and time consuming when I make entries. I have not been
able to find any info.
Perhaps you can help.
Thanks Harold