How to Fix Hash Symbols in Word Mail Merge Number Previews on Mac
Question details
The user is experiencing an issue where numerical data in a Word mail merge preview is displaying as hash symbols instead of actual numbers on a Mac.
- Product
- Word for Mac
- Device & OS
- macOS
- Scenario
- Previewing a mail merge document linked to a data source containing numeric fields.
- Observed behavior
- The merged numeric fields show up as a series of hash symbols (e.g., ####) rather than displaying the expected numbers or currency values.
Ensure that your linked data source (such as an Excel spreadsheet) contains clean, valid numerical data without hidden characters or mismatched formatting before initiating the merge.
Apply a Numeric Switch to the Merge Field Code
Modify the background field code in Word to explicitly tell it how to format and display the incoming numbers.
When Word connects to a data source, it sometimes loses the original numeric formatting, resulting in unreadable hash symbols. Adding a numeric switch manually forces Word to interpret and display the numbers correctly.
Press 'Option + F9' (or 'Fn + Option + F9' depending on your Mac keyboard settings) to toggle the display from preview text to field codes. The field will look something like { MERGEFIELD Price }.
Click inside the bracket, right after the field name, and type a numeric switch. For example, to format as currency, add \# "$#,##0.00" so the entire code reads { MERGEFIELD Price \# "$#,##0.00" }.
Press 'Option + F9' again to hide the field codes, then click 'Update Labels' or toggle the 'Preview Results' button to view the corrected numbers.
Adjust Document Margins and Column Widths
Fix spacing issues that force numbers to compress into hash symbols due to inadequate visual space.
Restart Word and Test with a Fresh Document
Eliminate the possibility of document corruption or temporary software glitches causing formatting rendering errors.
Perform Seamless Mail Merges with WPS Writer
If formatting glitches in Microsoft Word are slowing you down, try using WPS Writer. WPS Office handles mail merges efficiently, correctly interpreting Excel data so your numbers look exactly how you intend them to.
- 1. Open WPS Writer: Launch WPS Office on your Mac and open a new or existing document.
- 2. Import Your Data: Go to the 'References' tab, click on 'Mail Merge', and choose 'Open Data Source' to select your spreadsheet.
- 3. Insert the Fields: Click 'Insert Merge Field' and select the numeric columns you want to include in your document.
- 4. Preview Accurate Results: Click 'View Merged Data' to instantly preview your merge fields with perfectly formatted numbers.
Frequently Asked Questions
Why do hash symbols appear instead of numbers in my mail merge document?
Hash symbols (#) usually indicate that the physical space (like a table cell or column) is too narrow to display the entire number, or that the application has lost the specific formatting instructions for that numeric string.
What is the keyboard shortcut to view field codes on a Mac?
To toggle field codes on Word for Mac, press Option + F9. If your Mac is set to use standard function keys, you may need to press Fn + Option + F9.
Can I format dates in a mail merge using similar switches?
Yes. While numbers use the \# switch, dates can be formatted using the \@ switch. For example, adding \@ "MMMM d, yyyy" to a date merge field will format the result as 'January 1, 2024'.
