I type 1 Excel puts .0001 in the cell
Posted by W. Stroh on August 05, 2001 8:09 AM
I've been using excel for awhile now without any problems.I don't know what has happened but when I type a number in a cell Excel multiplies it by .0001 and that is what shows up in the cell. I went into some of my old spreadsheets and the numbers are still as I entered them; however, if I try to enter a new number in these cells the same thing happens. For example if I wanted to the number one to show up in the cell I would have to type 10000. Is there some kind of global setting or something that I have inadvertantly changed.