How to Display Dollar Signs in Acrobat PDF Mail Merge
Question details
The user needs to retain dollar signs and currency formatting when importing numerical data from an Excel spreadsheet into a PDF using the mail merge feature.
- Product
- Adobe Acrobat
- Device & OS
- not provided
- Scenario
- Creating automated PDF documents through a mail merge where financial data from a source spreadsheet is required to display correctly with currency symbols.
- Observed behavior
- The generated PDF documents strip the dollar signs and display only raw numbers, despite the source data being formatted as currency in Excel.
Make sure you have editing access to the original Excel source file, as resolving the formatting issue directly in the spreadsheet is much more efficient than editing individual PDFs.
Convert Currency Formatting to Text in the Source Spreadsheet
The most efficient and reliable way to ensure dollar signs appear in your generated PDFs is to format the currency cells as text using a formula in Excel before starting the mail merge.
Mail merge tools often pull the underlying raw data from a spreadsheet rather than the visual formatting. By converting the numbers into text strings that explicitly include the dollar sign, you force the merge engine to read and export the symbol exactly as it appears.
Launch Microsoft Excel and open the spreadsheet containing the data you plan to merge.
Insert a new column next to your existing currency data. Use the TEXT function to convert the value. For example, if your original value is in cell A2, type '=TEXT(A2, "$#,##0.00")' into the new cell and press Enter.
Drag the fill handle down to apply this formula to all the necessary rows in your spreadsheet.
Save your spreadsheet, then return to your mail merge application to re-import the data, ensuring you select the newly created text column as the merge field.
Manually Edit Text within Adobe Acrobat
If you cannot modify the source data or only have a few missing dollar signs, you can manually type them directly into the finalized PDF using Acrobat's editing tools.
Create Flawless Mail Merges to PDF with WPS Office
Streamline your document generation by using WPS Office. With powerful native mail merge capabilities between WPS Spreadsheets and WPS Writer, you can effortlessly lock in your currency formatting and export directly to PDF in batches.
- 1. Prepare data in WPS Spreadsheets: Open your data source in WPS Spreadsheets and format your currency columns.
- 2. Start Mail Merge in WPS Writer: Open your document template in WPS Writer, navigate to the 'References' tab, and click 'Mail Merge'.
- 3. Link data and insert fields: Click 'Open Data Source' to link your spreadsheet, then insert the relevant fields into your document.
- 4. Merge and export to PDF: Click 'Merge to New Document' to generate the files, then use the built-in 'Export to PDF' tool to save them flawlessly.
Frequently Asked Questions
Why do dollar signs disappear during a PDF mail merge?
When you apply currency formatting in a spreadsheet, the software often only changes how the number looks visually, keeping the underlying data as a raw number. Mail merge tools extract this raw underlying data, which results in the visual dollar sign being left behind.
Can I edit the missing dollar signs using Adobe Reader?
No, Adobe Acrobat Reader is a free application primarily designed for viewing, printing, and commenting on PDFs. To edit the actual text inside a PDF, you need a full editor like Adobe Acrobat Pro or a comprehensive alternative like WPS PDF.
Is there a way to make Word or Acrobat respect Excel's visual formatting?
If you are using Microsoft Word to merge before converting to PDF, you can press Alt+F9 to view field codes and add a numeric picture switch (e.g., \# "$#,##0.00") to force the formatting. However, transforming the data via the TEXT function in the source spreadsheet is universally more reliable.
