Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
sherobot sherobot is offline
external usenet poster
 
Posts: 11
Default mail merge and excel data

I have an excel sheet that has numbers calculated on it and I'm bringing
those numbers into a word doc by using a mail merge. Does anyone know how to
make the numbers have the correct formatting (i.e. $12,876.00) once it merges?
Or can you tell me how to change the formatting using fields once the data
has been merged?
Thanks
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default mail merge and excel data

Usually you can use Alt-F9 to display the field code, e.g.

{ MERGEFIELD myamount \*Mergeformat }

and add a numeric "format switch", e.g.

{ MERGEFIELD myamount \#"$,0.00" \*Mergeformat }

Then Alt-F9 again to reveal the result, and if necessary, slect the field
and press F9 to update it.

Peter Jamieson


"sherobot" wrote in message
...
I have an excel sheet that has numbers calculated on it and I'm bringing
those numbers into a word doc by using a mail merge. Does anyone know how
to
make the numbers have the correct formatting (i.e. $12,876.00) once it
merges?
Or can you tell me how to change the formatting using fields once the data
has been merged?
Thanks



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
sherobot sherobot is offline
external usenet poster
 
Posts: 11
Default mail merge and excel data

That worked great, thank you!

"Peter Jamieson" wrote:

Usually you can use Alt-F9 to display the field code, e.g.

{ MERGEFIELD myamount \*Mergeformat }

and add a numeric "format switch", e.g.

{ MERGEFIELD myamount \#"$,0.00" \*Mergeformat }

Then Alt-F9 again to reveal the result, and if necessary, slect the field
and press F9 to update it.

Peter Jamieson


"sherobot" wrote in message
...
I have an excel sheet that has numbers calculated on it and I'm bringing
those numbers into a word doc by using a mail merge. Does anyone know how
to
make the numbers have the correct formatting (i.e. $12,876.00) once it
merges?
Or can you tell me how to change the formatting using fields once the data
has been merged?
Thanks




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 with excel data bronxbabe Mailmerge 4 December 6th 06 05:21 AM
Mail Merge with Excel Data Jonathan L. Mailmerge 1 August 5th 06 08:33 PM
Data frm excel to word using mail merge Param Mailmerge 1 March 30th 06 07:40 PM
Mail Merge w/ Excel Data PFLY Microsoft Word Help 2 May 5th 05 04:17 PM
MAIL MERGE USING EXCEL DATA lfaraglia Mailmerge 4 January 26th 05 10:59 PM


All times are GMT +1. The time now is 06:11 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"