How can I avoid Excel reformatting the scientific notation numbers I enter?

Posted by Diomidis Spinellis on Super User See other posts from Super User or by Diomidis Spinellis
Published on 2009-09-01T14:48:02Z Indexed on 2012/10/01 15:43 UTC
Read the original article Hit count: 153

Filed under:

When I enter a number like 8230e12 into a Microsoft Excel 2000 cell, Excel changes the number I entered into 8230000000000000. (This is what I get when I press F2 to edit the cell's contents, not what Excel displays in the cell). How can I force Excel to keep the data in the format I typed it and still be able to format it and use it as a number? Displaying the cell in scientific notation is not enough, because the exponent is not the same one as the one I typed.

© Super User or respective owner

Related posts about microsoft-excel