Tools/ Options/ Edit
Uncheck: Fixed Decimal Places
--
David Biddulph

"Douglas" wrote in message
...
...
By default the number I type in a cell should stay the same once I enter
it
- e.g.
when I type in 19 and press Enter the figure in the cell should still read
19.
However it changes to 0.19. Do you know how to rectify this problem/