Mail merge between Word and Excel

[greg]

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

\#£,0.00

so you have

{ MERGEFIELD myamount \#£,0.00 }

Use Alt-F9 to toggle back again.

Peter Jamieson

http://tips.pjmsn.me.uk