Why are the data always divided by 10 in Excel?

  • Thread starter Thread starter Babychris
  • Start date Start date
B

Babychris

I wanted to use Excel to enter some numbers, but whatever I typed in, the
number is automatically divided by 10.
That is, when I key in "5" and I press "Enter", the number automatically
becomes "0.5", and likewise, when I key in "100" and press Enter, the number
becomes "10". It just seemed that I was using a calculator for book-keeping,
but I did not manage to find where can I change the option.
In fact, what is going wrong, and how can I fix it? Thanks
 
Hmmm, sounds like you need to check this out...

if you are using a file you have used before, sounds like you have some cell
formatting applied. Key your number, then change the cell format to
"general" and see if it replaces the "divide by 10" format. This is a new
one on mel....

if its happening when you hit ENTER, sounds event driven and there might be
some wacky code in the module attached to the spreadsheet. Check out the
module and see.
 
Back
Top