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

"If you wish Excel to keep the cell formatted exactly as entered, i.e. 8230e12, regardless of whether you are looking at it or editing it, then this can't be done whilst retaining the ability to treat the cell contents as a number.

The only way I can see round this is to enter your data in cells that are formatted as text, and then have another cell, formatted as some kind of number, that has a formula of =VALUE(A1) or whatever so that calculations can be performed on this cell.

Other than that you are looking at some VBA to manage this, overkill I would have thought."

"I had this with list of long numbers, about 14000 entered into one column. I highlighted the column, Data -> Text to Columns -> Fixed length -> Don't create any break lines. Clear any that show up -> Select column data format text -> Finish.
Worked like a charm."

"I had the same issue with a big number that I wanted without the exponent I solved it using Text function from Excel. in vba just do:

Application.WorksheetFunction.Text(Cells(myrow,mycol).Value(), ""0"")

Change the ""0"" with the format you need.
Voilà :)"

"This Works:
1. Highlight the column
2. Right click ""Format Cells...""
3. From the number Tab, Select Category=Number and ensure Decimal Place is set to Zero (unless you have decimal values in the cell content)
4. OK"

As @FoleyIsGood commented: Instead of inputting it with "e" notation, write it out explicitly: = 8230 * 10^12.