Exporting formatted data to Word mail merge | Excel forum

Hi Thomas

Thanks for your question

As discussed I have passed this question over to a colleague with better knowledge of word mail merge than my self

Regards

Stephen

Hi Thomas,

Thank you for your question and welcome to the forum.

In the Word document can you reveal the Merge Field codes by using ALT+F9. Edit the merge field containing the data. It will probably look something like this:

{MERGEFIELD "Salary"}

For your predicament try:

{MERGEFIELD Salary\#,##0}

The line above means number format followed by 0 decimal places.

If you edit the field code as below, it will give you the currency symbol followed by two decimal places.

{MERGEFIELD Salary\#£#,##0.00}

I hope this answers your question.

Regards

Simon