Office for Mac Issues

Fix Excel for Mac PDF Export Removing Commas from Numbers

Maira Mehtab Sep 20, 2026 868 views

Question details

Users experience formatting loss where commas in numerical values are replaced by spaces when saving an Excel spreadsheet as a PDF.

Product: Microsoft Excel
Device & OS: macOS
Scenario: Exporting or saving an Excel spreadsheet to a PDF format on a Mac.
Observed behavior: Commas in numeric values are missing or replaced by spaces in the generated PDF, whereas commas in text fields remain unchanged.

Before you start

Ensure your Mac operating system and Excel application are up to date, as updates often contain fixes for rendering issues related to PDF exports.

Solution 1Recommended

Select the "Best for Printing" Option When Saving

Changing the PDF export setting from electronic distribution to printing resolves the comma rendering issue.

Excel for Mac offers two distinct rendering engines when exporting to PDF. The default engine for electronic distribution may misinterpret numeric formatting, causing commas to disappear. Switching to the printing engine bypasses this bug.

Open the Save As dialog

Open your spreadsheet in Excel for Mac, go to the "File" menu in the top menu bar, and select "Save As".

Select PDF format

In the Save dialog box, click on the "File Format" dropdown menu and choose "PDF" from the list of formats.

Change the export setting

Below the format dropdown, locate the quality options and select the radio button for "Best for printing" instead of "Best for electronic distribution and accessibility".

Save the file

Click "Export" or "Save" to generate your PDF. The numbers will now display with their commas intact.

Formatting Preserved: This method ensures that all numeric punctuation, including full stops and commas, mirrors exactly what you see in the spreadsheet.

Solution 2

Use the macOS Print to PDF Workflow

Bypassing Excel's native export and using macOS's built-in print-to-PDF engine preserves all number formatting perfectly.

Free Microsoft Office alternative

Export Spreadsheets to PDF Flawlessly with WPS Office

If Excel for Mac keeps altering your formatting during exports, try WPS Office. It provides a lightweight, free alternative with a highly reliable PDF conversion tool that preserves all your numbers, commas, and layouts exactly as they appear on screen.

1. Install WPS Office: Download and install WPS Office for Mac from the official website.
2. Open your spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx or .xls file.
3. Export without errors: Go to the "Menu", click "Export to PDF", and save your file with perfect number formatting.

Highly compatible with Microsoft Excel (.xlsx, .xls) and CSV formats.Built-in, high-quality PDF exporter that preserves all cell formatting without bugs.Free and lightweight alternative specifically optimized for Mac users.Familiar tabbed user interface for a zero-learning-curve transition.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel for Mac remove commas when saving to PDF?

This is a known rendering bug with Excel for Mac's "Best for electronic distribution" PDF export engine. It sometimes misinterprets custom number formats during conversion, replacing commas with blank spaces.

Will commas in text cells also disappear during PDF export?

No, the issue typically only affects formatted numeric values. Commas used within text strings usually remain intact regardless of the export method you choose.

Does updating Excel fix the PDF number formatting issue?

Sometimes Microsoft releases patches for export bugs in newer updates. However, if the issue persists in the latest version, using the "Best for printing" or macOS "Print to PDF" methods remain the most reliable workarounds.

Office App Problems