A long identifier is not a number to calculate.
Order references, card-like identifiers and other long digit strings may exceed Excel’s numeric precision. Microsoft documents a limit of 15 significant digits for numbers. An identifier with 16 or more digits can change if an import converts it to a numeric cell.
A warning before conversion
For example, 243233597526377476 is preserved as a string by this checker. Its length triggers a review flag. The checker does not calculate an “Excel result”: the actual behavior depends on Excel version, settings and import path.
Import the source as Text
- Use an untouched original CSV, not a file already saved after rounding.
- Choose Data → From Text/CSV and inspect the delimiter and preview.
- Before loading, explicitly set identifier columns to Text. In Power Query, review any automatically inferred type-changing step before applying conversions.
- Compare representative values—including their final digits—with the original file.
Changing the display format or making a column wider does not recover digits already lost. If the source itself has been overwritten, this tool cannot reconstruct the original identifier.
Scientific notation needs context
12E3 may be an intended number or a product code. A pattern alone cannot decide. This checker flags it for review without converting it.
Source: Microsoft’s leading-zero and large-number guidance. There are free solutions in Excel; this checker is a quick way to identify which original columns deserve attention.
Also read: keep leading zeros on import.