Fix Number Alignment in Excel for Mac PDF Exports
Question details
Correct number alignment and missing digits when exporting an Excel for Mac worksheet to PDF.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- A worksheet contains currency and general number formats in the same column and is exported to PDF.
- Observed behavior
- Numbers in the PDF may appear staggered, lose their final digit, or no longer appear right-aligned.
Check that the values and final digits are correct in the worksheet before exporting. Note whether the workbook originated in QuickBooks, and keep a PDF export available for comparison.
Apply consistent number formatting and alignment
Use this approach when mixed formats or a narrow column may be affecting the PDF layout.
In Excel, select the cells or column containing the numbers that appear incorrectly in the PDF.
Open Format Cells and select Number or Currency on the Number tab. Choose the appropriate decimal places and apply the same format to comparable values.
On the Home tab, choose Align Right for the selected cells. Widen the column by dragging its header boundary or double-clicking the boundary to AutoFit.
Use File > Save As and choose PDF, or use File > Print and the PDF menu. Open the PDF and compare the affected numbers with the worksheet.

Test the export in a new workbook
Use a fresh workbook to check whether the behavior is specific to the original file or a QuickBooks export.
Try WPS Spreadsheets for PDF Export
WPS Office is a free, lightweight alternative with a familiar interface for opening Excel workbooks and exporting spreadsheets to PDF. It does not fix Excel for Mac itself, but you can compare its PDF output with Excel's.

Frequently Asked Questions
Why do numbers look staggered in my Excel PDF?
Mixed number formats, alignment settings, or column width may affect how values appear. Select the affected cells, check their formats in Format Cells, and use Home > Align Right before exporting again.
How can I check whether the final digit is missing from the worksheet or only the PDF?
Select the affected cell in Excel and check its value in the formula bar. Compare that value with the displayed worksheet cell and the exported PDF, then widen the column and export again.
Should I format every value as currency?
Only use Currency when a currency symbol is appropriate for the values. Otherwise, select the cells and choose a consistent Number format with suitable decimal places in Format Cells.
Could a QuickBooks export be related to the problem?
It may be relevant to the workbook's formatting, but it is not necessarily the cause. Create a new Excel workbook, manually enter similar values, and export it to PDF to see whether the issue also occurs there.




