Fix Indian Number and Date Formats in Word Mail Merge
Question details
The user needs Indian number, currency, and date formats to appear correctly in a Word mail merge.

- Product
- Microsoft Word Mail Merge and Microsoft Excel
- Device & OS
- not provided
- Scenario
- An Excel worksheet supplies numeric and date values to a Word mail merge document.
- Observed behavior
- Word may group digits in sets of three instead of using the Indian numbering pattern, even when regional settings or numeric field switches are applied.
Confirm which Excel columns contain the source numbers and dates, and check that the dates are stored as actual Excel dates. The number formula below requires a version of Excel that supports LET and works for values with an absolute rounded value below 1,00,00,00,000.
Merge formatted text from Excel helper columns
Use helper columns when Word does not preserve Indian digit grouping or the desired date format.
The number formula constructs Indian digit groups as text rather than relying on Word's numeric field switches or a locale-dependent Excel number format. The example produces currency values with two decimal places.
In Excel, add a column with a heading such as IndianCurrency. If the source value is in B2, enter this formula in the helper cell: =LET(n,ROUND(ABS(B2),2),w,INT(n),IF(B2<0,"-","")&"₹ "&IF(w<1000,TEXT(w,"0"),IF(w>=10000000,TEXT(INT(w/10000000),"0")&",","")&IF(w>=100000,TEXT(MOD(INT(w/100000),100),IF(w<10000000,"0","00"))&",","")&IF(w>=1000,TEXT(MOD(INT(w/1000),100),IF(w<100000,"0","00"))&",","")&TEXT(MOD(w,1000),"000"))&"."&TEXT(MOD(ROUND(n*100,0),100),"00"))
Add a column named FormattedDate. If the source date is in C2, enter =TEXT(C2,"dd/mm/yyyy") to produce a date such as 25/12/2025.
Drag the helper-cell fill handles down through the source rows, check several positive, negative, and decimal values, and save the Excel workbook.
In Word, use Mailings > Select Recipients to select or reconnect the saved workbook. Replace the original fields using Mailings > Insert Merge Field and choose IndianCurrency and FormattedDate.
Select Mailings > Preview Results and move through several records. If the values look correct, choose Finish & Merge.

Work with spreadsheets and documents in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets and documents. Its Microsoft Office format compatibility makes it easier to move existing files into your workflow, although it does not fix Word's mail merge formatting behavior.

Frequently Asked Questions
Why does Word show 123,456,789.10 instead of 12,34,56,789.10?
Word's numeric field formatting may group digits in sets of three rather than using the Indian grouping pattern. Generate the formatted value as text in an Excel helper column and insert that column through Mailings > Insert Merge Field.
Can I use the helper column for numbers without a currency symbol?
Yes. In the Excel formula, remove the &"₹ " portion, then fill the formula down and insert the helper column as a merge field in Word.
Why does my date helper show an error or an unexpected value?
The TEXT formula expects a valid Excel date value. Check the source cell in Excel and convert any text dates to actual dates before using =TEXT(C2,"dd/mm/yyyy").
What should I check before completing the mail merge?
Use Mailings > Preview Results to inspect multiple records, including small and large amounts, negative values, decimals, and dates. Confirm that the replacement merge fields have no numeric or date formatting switches.




