Site logo white shadow

How to solve number formatting problem in mail merge

Common problem.

Solution is to use TEXT function.

mail merge data formatting problem - Dr. Nitin paranjape

Estimated reading time 3 min

The Problem

Look at the data in Excel. The date and amount column has custom formatting.

Now if we use this data in Mail Merge using Word, the data is shown correctly – but the formatting is NOT shown. This is a big issue.


Add another column for each formatted column and translate the NUMBER formatting into simple text using the TEXT function.

How does the text function work? Well, it takes the custom format which we put in the Format Cells dialog as a parameter and produces text output.


Now that you know this concept, you can use it to your advantage. Use the Text function to apply the desired formatting to the original column and use this TEXT function based columns in the Word Mail Merge document. That’s it.


2 Responses

Queries | Comments | Suggestions | Wish list

Subscribe to Blog

Join 1,755 other subscribers

Popular articles

Pivot Table Pro Course

Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.

Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.