1 becomes 10, how can I stop this
 

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

1 becomes 10, how can I stop this
 

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

1 becomes 10, how can I stop this
 

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


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

1 becomes 10, how can I stop this
 

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

Hi HerbalDave

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

Regards

Steve

1 becomes 10, how can I stop this
 

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