MrExcel Publishing
Your One Stop for Excel Tips & Solutions

getting rid of scientific notation

Posted by Todd on July 25, 2001 1:16 PM

Is there any way to shut off the apparent automatic scientific notation conversion in Excel? Ex: I enter "001E2"....and Excel assumes I mean "1.00E+02". Thanks.

Posted by lenze on July 25, 2001 2:56 PM

Inform Excel you are not entering a number by using an apostrophe ' before you enter the number. That will make you entry text. Th apostrophe will not display.

Posted by Mark W. on July 25, 2001 4:38 PM


Format the cell, row or column as "Text" before
you enter the value.