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: 148
microsoft-excel
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