You convert a PDF to Excel, open the file, and a routing number that should read 00123456 now shows 123456. A 16-digit card number has become 1.23457E+15. A ZIP code lost its front zero. The conversion did not corrupt your data, Excel did, the moment it decided those strings were numbers and reformatted them. This trips up anyone moving account numbers, invoice IDs, product codes, or check numbers out of a PDF, and it is one of the most frustrating parts of the job because the file looked fine in the PDF.
This guide explains why Excel strips leading zeros and switches long numbers to scientific notation, and gives you reliable ways to keep those values intact. The converter at the top of this page reads the table structure directly, so try your file first, then use the fixes below for anything Excel still reformats.
Why does Excel drop the leading zeros after I convert a PDF?
Excel drops leading zeros because it treats any string that looks like a number as a number, and numbers do not carry meaningless front zeros. To Excel, 00123 and 123 are the same quantity, so it stores 123 and throws the padding away. That is correct behavior for a quantity like a dollar amount, but wrong for an identifier like an account number, a ZIP code, or a product SKU, where the zeros are part of the label and not a measure of size.
The conversion step is rarely the culprit. The values come out of the PDF correctly, and then Excel applies its General number format on import and reformats them. Knowing that the problem is Excel's formatting, not lost data, points you straight at the fix: tell Excel to treat those columns as text.
Why does Excel turn long numbers into scientific notation?
Excel converts any number longer than about 15 digits into scientific notation and rounds it to 15 digits of precision. A 16-digit card number or a long account number exceeds that limit, so Excel displays 1.23457E+15 and, worse, permanently rounds the trailing digits to zeros. Unlike leading zeros, this one can destroy data: once the cell is stored as a number and rounded, the original digits are gone even if you reformat the cell afterward.
That makes scientific notation the more dangerous of the two problems. It is also why you have to set the column to text before or during import, not after. Reformatting a cell that has already been truncated will not bring the lost digits back.
How do I keep leading zeros when converting a PDF to Excel?
The reliable approach is to make sure the identifier columns are treated as text, not numbers. You have a few ways to do it:
- Format the column as Text first. In a blank sheet, select the columns that will hold account numbers or codes, set their format to Text, then paste or import. Excel keeps every character exactly as it arrives, zeros included.
- Use a custom number format. If the values are genuinely numeric and you only need them displayed with padding, apply a custom format like 00000. The underlying value stays numeric but always shows the right number of digits. This is good for fixed-length codes like ZIP codes.
- Turn on Automatic Data Conversion settings. Newer versions of Excel let you switch off automatic removal of leading zeros and the truncation of long numbers under File, Options, Data. This protects future imports without per-column work.
For true identifiers like card and account numbers, text is the safer choice because it also defeats scientific notation. A display format alone does not.
How do I stop account and routing numbers from changing in Excel?
Set those columns to Text before the numbers ever land in them, because that is the only method that protects both the leading zeros and the full digit length. Custom formatting fixes how a number looks but does nothing about the 15-digit rounding, so a long account number stored as a number is already damaged before you format it. Text storage keeps all the characters and never rounds.
A simple rule for finance data: if you would never add, subtract, or average a column, it is an identifier, and identifiers belong in text. Account numbers, routing numbers, check numbers, invoice numbers, and customer IDs all fall in that bucket. Dollar amounts and quantities stay numeric so you can total them.
Should account and routing numbers be stored as text or numbers in Excel?
Store them as text. The only reason to keep something numeric is to do math on it, and you never sum routing numbers. Storing identifiers as text preserves leading zeros, prevents scientific notation, stops Excel from rounding long values, and keeps the data import-ready for accounting software that expects those fields as strings. The one tradeoff is that text-stored numbers sort character by character rather than by value, which is rarely an issue for fixed-length codes.
If a downstream system truly needs the field numeric, convert it at that stage with a documented step, not by letting Excel guess on import. Guessing is how the zeros disappear in the first place.
Does converting a PDF to CSV instead of Excel keep leading zeros?
The CSV file itself keeps every character, because CSV is plain text with no formatting and no concept of a number type. The leading zeros are preserved in the raw file. The catch is that they can still vanish the moment you open that CSV by double-clicking it, because Excel applies the same automatic number conversion on open that it does on any import. So the format is safe, the way you open it is not.
To keep the zeros from a PDF to CSV conversion, do not double-click the file. Open Excel first, use Data then From Text/CSV, and set the relevant columns to Text in the import dialog. Or import the CSV straight into the accounting or database system that needs it, skipping Excel entirely. If you want a ready-to-use spreadsheet rather than raw text, a clean PDF to XLSX conversion with the identifier columns set to text gives you the same protection with formatting intact.
However you get the data out, the principle is the same. Decide which columns are identifiers, keep them as text, and Excel will stop rewriting your numbers. The accurate PDF to Excel converter at the top of this page pulls the values out of the PDF cleanly, and these steps keep them that way once they reach the sheet. It is the same discipline that keeps reconciliations clean for accountants and everyday PDF to Excel work.