Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Stuart Stuart is offline
external usenet poster
 
Posts: 21
Default Mail merge field formatting from excel

I am trying to merge data from excel into word using mail merge. How do I
format the mail merge field so that it displays the currency figure or if the
figure is zero it leaves the field blank
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Mail merge field formatting from excel

You will; need a formatting switch eg
{Mergefield fieldname \@ "$,0.00;($,0.00); }
See http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Stuart wrote:
I am trying to merge data from excel into word using mail merge. How
do I format the mail merge field so that it displays the currency
figure or if the figure is zero it leaves the field blank



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
Formatting a Mail Merge Field Angela Mailmerge 2 May 24th 06 08:36 PM
Mail merge field formatting Judy123 Mailmerge 3 April 26th 06 02:43 PM
Excel Formatting in Mail Merge dpahlow@nwtc Mailmerge 1 July 29th 05 06:25 PM
Insert Merge Field problem with Word-Mail Merge from Excel documen Augusta E. Microsoft Word Help 2 June 20th 05 10:59 AM
Formatting Field In Mail-Merge Jerry Mailmerge 2 June 9th 05 08:48 PM


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

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

About Us

"It's about Microsoft Word"