Why does Excel change my numbers when I open a file?
Excel can convert imported text into numbers or dates, removing leading zeros or changing long identifiers. Numeric values have at most fifteen significant digits. Scientific notation alone is a display format, not proof that data changed: inspect the formula bar and compare with the source. Preserve identifier columns as Text before import rather than trying to repair them afterward.

Section 01
Why did Excel delete my leading zeros?
A postcode, product code or account number beginning with zero is a number as far as a type guesser is concerned, so 01234 becomes 1234. The cell looks fine. The join against another file silently matches nothing.
This is the one to check first whenever a lookup returns fewer rows than you expected. Sort the column and look at the shortest values: if some are one character shorter than the rest and start with a different digit, this happened.
Import identifier columns as Text before Excel converts them. A CSV has no column-type metadata, so asking an exporter to write digits as text does not reliably tell Excel to preserve them when the file is opened directly.
Section 02
Why does Excel change the last digits of long numbers?
Excel's numeric precision is limited to fifteen significant digits. A longer identifier stored as a number can lose trailing digits, which become zeros. A quantity and an identifier need different treatment even when both contain only digits.
The tell is a column of long numbers where a suspicious number of them end in zero. Nothing about the cell indicates that it was truncated, and once saved, the original digit is not recoverable from the file.
Signature to look for: identifiers of a fixed length where the final character is zero far more often than one time in ten.
Section 03
Why did Excel turn my product codes into dates?
A code such as 3-10 can be interpreted as a date. The result depends on the import path and regional settings; the same-looking code does not imply the same date on every machine. Compare the imported value with the raw file before choosing a correction.
It is not reversible by formatting the cell back, because the underlying value is now a serial number and the original text is gone. Undo works; reformatting does not.
Section 04
Why does Excel show my number as 1.23E+15?
Scientific notation alone does not change a stored numeric value. Select the cell and inspect the formula bar; widening the column or changing its number format may reveal a value that was intact all along. If digits were already lost during numeric conversion, changing the display will not restore them.
The general rule underneath all four: a spreadsheet is a calculation tool that assumes its input is quantities. Identifiers are not quantities, and the safest thing you can do with a column of codes is to make sure nothing ever reads it as numeric.
Section 05
How do I stop Excel changing a CSV when I import it?
Use Data > From Text/CSV and open the transformation editor before loading. Set identifier columns to Text, replacing an automatically inferred type step where necessary, then load and check sample values against the unchanged source.
In Excel for Microsoft 365 and Excel 2024, the Automatic Data Conversions settings provide additional controls. Availability and menus vary by version. Microsoft's linked instructions below cover supported versions; older installations can use an explicit text import instead.
Try a small synthetic check before your real file: include 00123, a long order identifier, and a date-like product code. Record what each should remain. Reopen any exported CSV in a text editor to check its actual characters rather than letting a second Excel import repeat the conversion.
Section 06
Can I recover the original numbers?
A display-only change needs a display correction. A converted or truncated identifier needs the original export or another authoritative source. Do not infer missing digits from a pattern or prepend zeros unless an independent schema establishes the required width.
Reimport into a new workbook, keep the damaged copy for comparison, and verify both row counts and identifiers. The rest of the analysis should wait until its keys are trustworthy: a total can still balance while every customer join is wrong.
See it on a real project
Product A produced 68% of total growth while repeat purchasing fell from 31% to 24%.
Keep reading
Evidence
Sources
- Microsoft (2026). Keeping leading zeros and large numbers.
- Microsoft (2026). Available number formats in Excel.
- Data Analysis App team (2026). Why spreadsheet totals disagree.