Immediate fix: Select the cells showing scientific notation → right-click → Format Cells → Number (or Custom: 0) → OK. The full number reappears.
Important caveat: Excel only stores 15 significant digits. If your numbers are longer than 15 digits, the digits beyond position 15 are permanently lost (replaced with zeros) — no formatting change can recover them. For identifiers longer than 15 digits, import as text instead.
Why Excel Does This
Excel converts numbers to scientific notation when they're too long to display in the cell's current width, or when it detects that a numeric value has more digits than its display precision can handle. It's a display shortcut that prioritizes showing "something" over showing nothing.
The deeper issue: Excel's numeric precision is 15 significant digits (64-bit IEEE 754 floating point). Any number with more than 15 digits has the excess digits stored as zeros internally, even if you paste in the full number.
The Fixes
Fix 1: Change Number Format (For Numbers ≤15 Digits)
- Select the cells with scientific notation
- Right-click → Format Cells (or Ctrl+1)
- In the Number tab: select Number (for regular numbers) or Custom and type
0(for integers without decimal places) - Click OK
See exactly what's wrong with your data — try Sohovi free — try Sohovi free.
If you need leading zeros (ZIP codes, serial numbers): use Custom format 00000 (or however many digits the field should have). This displays the number with leading zeros but the underlying value is still a number — it doesn't actually store the leading zero.
Fix 2: Import as Text (Best Prevention — Before the Problem)
If your large numbers represent identifiers (order IDs, phone numbers, barcode numbers), they should be text, not numbers:
- Don't double-click the CSV — use Data → From Text/CSV
- In the import wizard: click on the column with long numbers
- Set the data type to Text
- Click Load
As text, Excel never attempts numeric conversion, so scientific notation never appears and no precision is lost.
Fix 3: Recover Lost Digits (Sometimes Possible)
If Excel has already converted your numbers and you can see that the last few digits are zeros where they shouldn't be — 1234567890123400 instead of 1234567890123456 — those digits are gone from Excel's memory. Recovery requires:
- Go back to the source system and re-export the original data
- Import as text this time (Fix 2)
If the source is gone, the data is lost. This is why prevention matters: numbers longer than 15 digits should always be imported as text.
Common Cases
| Number type | Digit count | Should be | |-------------|-------------|-----------| | Order/invoice IDs | Usually ≤15 | Number or text (depends on whether you do math on them) | | Barcode / EAN-13 | 13 digits | Text (leading zeros, no math) | | US phone numbers | 10–11 digits | Text (leading zeros matter) | | International phone | Up to 15 digits | Text | | SWIFT codes | 8–11 chars | Text (alphanumeric) | | Long product codes | Variable | Text |
Scientific Notation in Formulas vs Display
Note: 1.23E+12 can appear in two different ways:
- Display issue only: The cell contains a full number but Excel is showing it in scientific notation due to column width or format — fix with Format Cells
- Value issue: Excel only stored 15 significant digits and the rest are zeros — fix by re-importing as text
To check which situation you have: click the cell and look at the formula bar. If the formula bar shows the full number, it's display-only. If the formula bar also shows scientific notation or truncated zeros, the precision is lost.
Frequently Asked Questions
Q: My column is wide enough but Excel still shows scientific notation. Why?
The column width affects display truncation (showing ########## when too narrow) but not scientific notation. Scientific notation appears based on the cell's format and the number's length — not column width. Apply the Format Cells fix regardless of column width.
Q: Can I prevent Excel from ever using scientific notation by default? Not system-wide — Excel applies scientific notation based on the number's magnitude and the cell format. The prevention is importing numeric-looking identifiers as text so Excel never treats them as numbers in the first place.
Q: Does this problem affect Google Sheets too? Yes — Google Sheets has the same 15-digit precision limit and will show scientific notation for longer numbers. Same fix: format the cell as Plain Text before entering or importing the data.
Profile your imported file for type conversion issues — Sohovi's profiler catches columns where numeric values have been silently truncated or reformatted. Upload free and see what Excel may have changed before you use the data.