MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.
W. Stroh

Posted by Andrew Cheung on August 05, 2001 8:29 AM

W. Stroh
I think you have default the Excel data in .0001 format, you can change back in "Tools-Options-Edit-(Item with 'Alt-X')" to unselect the box and you can change back the decimal place.


Posted by W. Stroh on August 05, 2001 11:53 AM

I am so embarrassed. I don't know when or why I changed that. Thank you very much.

W. Stroh