Mail merge between Word and Excel



Hi, i am trying to merge a word document with an excel spreadsheet which
contains some field that are formated as currency in excel, however, when
they are merged with the word doc the numbers do not appear.

how do i format the merge field in the word document to appear as a number
e.g £1,234.90

please help

Peter Jamieson

In Word, use Alt-F9 to display the field(s) you want to format, e.g.

{ MERGEFIELD myamount }

Delete \*Mergeformat if you see it, and type in the following numeric format


so you have

{ MERGEFIELD myamount \#£,0.00 }

Use Alt-F9 to toggle back again.

Peter Jamieson

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads