When I type 100 EXCEL changes it to 10. Why?

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

Guest

When I type numbers into my EXCEL sheets it reduces the number by 1 number. I
have changed the format of the cell multiple times in an effort to correct it
and nothing seems to work. I will type 20 and EXCEL will show 2. I changed
the number of decimal places and it still shows 2. Does anyone know how to
turn this feature off?
 
select Tools - Options.
On the Edit tab make sure the Fixed Decimal option is not ticked.

Nick
 
<Tools> <Options> <Edit> tab,

And *UNCHECK*
"Fixed Decimal Places".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

When I type numbers into my EXCEL sheets it reduces the number by 1 number.
I
have changed the format of the cell multiple times in an effort to correct
it
and nothing seems to work. I will type 20 and EXCEL will show 2. I changed
the number of decimal places and it still shows 2. Does anyone know how to
turn this feature off?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

when I type numbers in a cell it changes it to a decimal point 4
Excel automatically changes numbers like1989to19.89 why? Help! 1
Why does 100 turn into 1 when I enter it into a cell? 3
Stop excel changing the value of numbers in european formt 7
How to Display 12.5 but not 25.0 (drop .0’s) 5
Decimal Numbers typed into Excel 2003 read as whole numbers 1
How to subtract a number from a Mergefield? 0
Equations and Text in same Cell 2

Back
Top