Mail merge between Word and Excel

  • Thread starter Thread starter greg
  • Start date Start date
G

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
 
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
 
Back
Top