Thanks to all that answered. By opening: Tools, Options, Tab Edit and
De-flaging fixed decimals, the problem was solved.
Many Thanks
DB

"HerbalDave" wrote:

Iv'e been working with basic formulas and worksheets for a short time. Today
I opened a saved sheet and found that when I use a number and enter to the
next cell, the number gains a zero ie 1 becomes 10. If anyone can help out
with this I'd be very grateful.

Many thanks

DB