1 becomes 10, how can I stop this

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Nel post *HerbalDave* ha scritto:
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
Click to expand...


Try with this (I'm not sure...):
Menu Tools, Options, tab Edit, deflag Fixed decimals


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
HerbalDave said:
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
Click to expand...

Hi HerbalDave

If custom formats aren't the probelm, check to see if a macro is
changing the cell.

Regards

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