check for the format of cells.
right click on the cell in which 1 turns to 10 select Format cell and
see for its format and change it to yor required format according to
your data.

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


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=557254