MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Typing a 4 and getting 0.04 in the cell!!

Posted by Johnny on September 20, 2001 12:46 AM

How the hell did this happen all of a sudden and how do I get rid of this formatting. Previous data have gone in as integers and now it throws fractions at me everytime I input a number.


Posted by Loren on September 20, 2001 4:10 AM

Tools Options Edit Fixed Decimal then uncheck

Posted by jon on September 26, 2001 1:00 PM

Sounds like you turned on a percent formatting on
that cell. Percent is sandwiched between time and
fractions, did you want one of those instead?