Excel number format

[Guest]

I am using Excel 2003. When I enter a number into a cell, it automatically
divides by 100 and displays in this format. eg 23 displays as 0.23. I have
formatted the cells as general format.

 

[Guest]

Try,

Tools|options|edit

uncheck fixed decimal places.

Mike

 

[Guest]

Many thanks - this has done the trick!

Try,

Tools|options|edit

uncheck fixed decimal places.

Mike

 

[David Biddulph]

Tools/ Options/ Edit:
Unset "Fixed decimal places".