How to stop numbers showing as scientific notation (1.23E+11)
✓ Verified in LibreOffice 25.8.7.3Show long numbers in full — and know when the real problem is the 15-digit limit.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =TEXT(A2,"0") | Or format the cell as Number with 0 decimals. For IDs, the real fix is importing the column AS TEXT. |
| Google Sheets | =TEXT(A2,"0") | Identical; Format → Number also works. |
| LibreOffice Calc | =TEXT(A2,"0") | Identical. |
How it works
Scientific notation is just the default DISPLAY for wide numbers — a "0" format (via TEXT or the cell format) shows all the digits: 1.23E+11 becomes 123000000000. The deeper trap: spreadsheets keep only 15 significant digits, so a 16-digit credit-card or barcode number is already silently corrupted (final digit becomes 0) the moment it's entered as a number — no format can bring it back. Long identifiers must be TEXT from the start: import the column as text or prefix entries with an apostrophe.
Verified, not just documented
We ran =TEXT(A2,"0") in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned 123000000000 — exactly the expected result. Every formula here is confirmed by actually executing it.