On Jan 9, 2:33*pm, "David Biddulph" <groups [at] biddulph.org.uk
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- Hide quoted text -

- Show quoted text -

Dave: Many thanks...I thought I had tried everything, but missed that
one.

Harold