You convert a PDF to Excel, open the file, and a line that should read 1,284.37 now shows 1,284. A unit price of 0.085 became 0. A total that ended in .99 rounded to a whole number. Missing decimals are one of the most common complaints after a PDF to Excel conversion, and they fall into two very different buckets: decimals that are still there but hidden, and decimals that the conversion genuinely lost. Telling them apart is the whole game, because the fixes are not the same.
This guide walks through both, in the order worth checking, so you can get every digit back and stop a rounded figure from quietly throwing off a total.
Why does my PDF to Excel conversion drop the decimals?
Most of the time the decimals are not dropped at all, they are hidden by formatting. Excel often opens a converted file in the General or whole-number format, or the column is too narrow, so it displays a rounded figure while still storing the full value underneath. The rest of the time the converter read the number as text or pulled only the rounded figure printed on the PDF. Click a cell and look at the formula bar: if the full number with decimals shows there, the value is intact and you only need to change how it is displayed.
Is Excel hiding my decimals or did the converter remove them?
Click the cell and read the formula bar at the top of the screen. If it shows 1,284.37 while the cell shows 1,284, Excel is rounding the display and your data is safe. If the formula bar also shows 1,284, the decimals are genuinely gone and you will need to reconvert with a better tool. This one check decides everything, so do it before you start reformatting or re-keying anything.
How do I keep decimal places when converting PDF to Excel?
Use a converter that reads the real number and writes it to the cell as a numeric value, not a rounded or text version. Upload your PDF into the converter at the top of this page, let it map the table, then check the preview before you download. Because amounts come through as true numbers, the decimals are preserved and you can set the display format you want. A quick habit that saves rework: in the preview, spot-check one or two figures you already know, like a total you can foot, and confirm the cents match before you download the whole file. For why structure-aware conversion keeps figures exact, see the accurate PDF to Excel converter.
How do I show two decimal places in Excel after converting?
Select the column, then on the Home tab choose the Number format or click Increase Decimal until you see two places, or press Ctrl+1 and pick Number with 2 decimal places. This changes only the display, not the stored value, so a figure like 1,284.3719 will show as 1,284.37 while keeping its full precision for calculations. Set the format once for the whole column so every amount lines up.
Why are my numbers rounded to whole numbers after converting a PDF?
Two causes. Either Excel applied a whole-number or General format on import, in which case the underlying value still has its decimals and a format change fixes it, or the PDF itself printed rounded figures and there were never any decimals to recover. A summary report that shows 1,284 on the page has no hidden .37 for any tool to find. When the source document is rounded, the only way to get exact cents is to convert the detailed statement, not the summary.
Why did the converter turn my amounts into text?
It happens when a converter copies the digits as characters along with commas or a currency symbol, which Excel then reads as text rather than a value. Text keeps every decimal but will not sum, sort, or feed a formula, and Excel flags it with a green triangle. The reliable fix is a converter that recognizes a number as a number on the way in. Here amounts arrive numeric, so the decimals are kept and a SUM works the moment the file opens.
Do scanned PDFs lose decimals more often?
They can, because a scan is an image and the figures have to be read by OCR before anything else happens. A faint or blurry decimal point can be misread, and a smudged 0.085 can come through as 0085 or 085. Good OCR for scanned PDFs reduces this, but a scan is never as reliable as digital text, so check the converted decimals against the source on important rows. For the full scanned workflow, see how to convert a scanned PDF to an editable Excel file.
Does converting a PDF to Excel change the actual values?
A good conversion should not change a single value. The figure in the cell should match the figure on the page, decimals and all, which is exactly why a preview before download matters: you confirm the numbers rather than trust them. If you find a changed value, it almost always traces back to a rounded source document, an OCR misread on a scan, or a number stored as text. Catching it in the preview takes seconds and saves a wrong total later.
Keep the cents, then move on
Run the formula-bar check first. If the value is whole there, reconvert with a tool that keeps numbers numeric, like the one at the top of this page, then set a two-decimal Number format for display. Decimals matter most on money, so the documents people fight with here are usually financial: see the workflow for converting any PDF to Excel or pull just the grids with the PDF table extractor. If the figures you need come from invoices, you can send those straight to a spreadsheet with an invoice to Excel converter, and when the source is a scan that needs careful digit recognition, an AI document OCR tool handles the image-to-text step before the numbers ever reach Excel.