Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Greg Greg is offline
external usenet poster
 
Posts: 113
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge in Word, from Excel, the merge results for a percentag. Conrad Klein Microsoft Word Help 1 November 12th 09 12:00 AM
MS Word Mail Merge from Excel -- Force Excel to open the datafile? [email protected] Mailmerge 6 September 26th 08 03:08 PM
How to merge Excel chart for mass Word Mail Merge for employees hmboomer Mailmerge 3 June 9th 06 10:08 PM
ExcelWord Mail merge transfers 16 digits when Excel shows only 3 John Richmond, Watford UK Mailmerge 8 April 26th 06 06:00 AM
Insert Merge Field problem with Word-Mail Merge from Excel documen Augusta E. Microsoft Word Help 2 June 20th 05 10:59 AM


All times are GMT +1. The time now is 01:56 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"