View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Franz Verga
 
Posts: n/a
Default 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