Restore lost leading zeros in an Excel file
A spreadsheet reads "01000" as the number 1000, and "3012345678912" as 3.01E+12. The tool pads codes back to the column's original length and writes long numbers out in full, as text, so they are not lost again.
What this tool does
- The original length detected per column (the longest one that comes up often), or set by you.
- Scientific notation undone when the file still holds every digit.
- Numbers that have already lost digits are flagged, never padded at random.
- The result is written as text: Excel can no longer strip the zeros.
What it does not do: A number shown as "3.01234567891E+12" only has twelve significant digits: the thirteenth is lost and no tool can recover it. Take it again from its source.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Fix a CSV file : Broken accents, everything in one column, lost zeros: a file Excel opens right the first time.
- Remove duplicates : On the columns you choose, optionally ignoring case, spaces and accents.
- Near-duplicates : "Smith Ltd" and "SMITH LTD.": the almost-identical duplicates, reviewed one by one.
- Clean text : Extra spaces, non-breaking spaces, line breaks, invisible characters, case.
- Convert text to numbers : "1,234.56 $", "(45.00)", "12.5-": real numbers that add up.