mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Omega Linda - 21 Jun 2005 21:19 GMT

I was just upgraded to windows XP. When I am in a word doc and perform a
mail merge, I select the existing Excel spreadsheet and merge. What comes
thru is the whole value of my cells...for instance -3108.1355 when in Excel I
have it formatted to be (3,108.14). I need the proper two decimal place
number with the parenthesis to appear on my mail merge.

Reply to this Message

Anne Troy - 21 Jun 2005 22:34 GMT

Try this, Linda:
http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

> I was just upgraded to windows XP. When I am in a word doc and perform a
> mail merge, I select the existing Excel spreadsheet and merge. What comes
> thru is the whole value of my cells...for instance -3108.1355 when in Excel I
> have it formatted to be (3,108.14). I need the proper two decimal place
> number with the parenthesis to appear on my mail merge.

Reply to this Message

Graham Mayor - 22 Jun 2005 05:44 GMT

There are two ways to do this - the first is\covered in the Excel data
section of http://www.gmayor.com/mail_merge_labels_with_word_xp.htm , but
the simpler method is to add a formatting switch to the field
http://www.gmayor.com/formatting_word_fields.htm which in this instance
would be

\# ",0.00;(,0.00)"

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> I was just upgraded to windows XP. When I am in a word doc and
> perform a mail merge, I select the existing Excel spreadsheet and
> merge. What comes thru is the whole value of my cells...for instance
> -3108.1355 when in Excel I have it formatted to be (3,108.14). I
> need the proper two decimal place number with the parenthesis to
> appear on my mail merge.

Reply to this Message