Formatting Issues

Fix Hijri Dates and Number Formatting in Word Mail Merge

Huma Ashraf ChHuma Ashraf Ch Nov 18, 2026 869 views

Question details

Preserve calculated Hijri dates and Excel number formatting when merging spreadsheet data into Word.

Fix Hijri Dates and Number Formatting in Word Mail Merge
Product
Microsoft Word and Microsoft Excel
Device & OS
not provided
Scenario
A user is creating a Word mail merge from an Excel worksheet containing Hijri dates and formatted numbers.
Observed behavior
Word may apply its own date and number formatting instead of displaying the formatting shown in Excel.
Before you start

Identify the Excel columns containing the source dates and numbers, and confirm which columns are used in the Word merge. The Hijri formula below uses an Arabic (Saudi Arabia) locale format, so test it against the date display you need.

Solution 1Recommended

Merge Hijri dates from an Excel text helper column

Use a helper column to send the displayed Hijri date to Word as text rather than as a numeric date value.

1
Add a helper column

In the Excel source worksheet, insert a new column and give it a header such as HijriDateText.

2
Convert the date to text

For a date in F25, enter =TEXT(F25,"[$-,106]B2d/mm/yyyy;@"). If the Hijri date is calculated from the Gregorian date in G25, use =TEXT(G25,"[$-,106]B2d/mm/yyyy;@") instead. Adjust the cell reference for your first data row.

3
Fill and save

Fill the formula down the helper column, check that the results show the intended Hijri dates, and save the workbook.

4
Insert the helper field

In Word, open the merge document and use Mailings > Select Recipients > Use an Existing List to select the saved workbook if needed. Use Mailings > Insert Merge Field to insert HijriDateText in place of the original date field.

5
Preview the merge

Select Mailings > Preview Results and check several records before selecting Finish & Merge.

Merge Hijri dates from an Excel text helper column
Keep the original date column: The helper column contains text, not numeric dates. Retain the original date column for calculations and test the displayed dates in your Excel locale.
Free Microsoft Office alternative

Work with Documents and Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working across documents and spreadsheets. Its Microsoft Office format compatibility helps make the move from Word and Excel seamless.

Work with formatted dates and numbers in spreadsheetsOpen and edit Microsoft Word DOCX and Excel XLSX filesUse a familiar interface for documents and spreadsheetsGet a free, lightweight office suite
QA img-9

Frequently Asked Questions

Why does my Hijri date change format in Word mail merge?

Word may apply its own formatting to the underlying Excel date value rather than use the worksheet's displayed format. Convert the date to text in an Excel helper column and insert that column through Mailings > Insert Merge Field.

Will the Hijri text column still work in date calculations?

No. Excel's TEXT function returns text rather than a numeric date. Keep the original date column for calculations and use the helper column for the merge.

How can I keep two decimal places in a merged number?

In Excel, create a helper column with a formula such as =TEXT(H25,"0.00"), fill it down, and save the workbook. In Word, insert that helper column using Mailings > Insert Merge Field and check it with Preview Results.

What if my new helper column does not appear in Word?

Save the Excel workbook, then in Word use Mailings > Select Recipients > Use an Existing List to reselect it. Check Mailings > Insert Merge Field for the new column header.