Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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 |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail merge between Word and Excel
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 On 17/05/2010 13:16, greg wrote: 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 |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail merge between Word and Excel
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 On 17/05/2010 13:16, greg wrote: 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge in Word, from Excel, the merge results for a percentag. | Microsoft Word Help | |||
MS Word Mail Merge from Excel -- Force Excel to open the datafile? | Mailmerge | |||
How to merge Excel chart for mass Word Mail Merge for employees | Mailmerge | |||
ExcelWord Mail merge transfers 16 digits when Excel shows only 3 | Mailmerge | |||
Insert Merge Field problem with Word-Mail Merge from Excel documen | Microsoft Word Help |