merge currency incl .00 from excel into word doc

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bamny - 05 Jan 2006 15:28 GMT

When merging a currency field from Excel, it will merge any cents (example
$23.32), but if it's zero cents, it will not print the zeros (example
$23.00). How do I get it to include the .00?

Reply to this Message

Doug Robbins - Word MVP - 05 Jan 2006 18:21 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> When merging a currency field from Excel, it will merge any cents (example
> $23.32), but if it's zero cents, it will not print the zeros (example
> $23.00). How do I get it to include the .00?

Reply to this Message

bamny - 05 Jan 2006 18:48 GMT

I appreciate your response, but it's way more than I can interpret. It
should be a simple matter for us technically-challenged people to do. Thanks
anyway!

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 4 lines]
> > $23.32), but if it's zero cents, it will not print the zeros (example
> > $23.00). How do I get it to include the .00?

Reply to this Message

Graham Mayor - 06 Jan 2006 06:52 GMT

The use of switches on fields is elementary stuff and if you want Word to
produce the merges you require you are going to have to bite the bullet and
learn about it.

Select the offending field which will probably look like
<<fieldname>>
Right click and toggle the display to show
{Mergefield fieldname}
Within the brackets add the switch

{Mergefield fieldname \# "$,0.00"}
Press F9 then if necessary toggle the display back again.

Signature

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

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

> I appreciate your response, but it's way more than I can interpret.
> It should be a simple matter for us technically-challenged people to
[quoted text clipped - 16 lines]
>>> (example $23.32), but if it's zero cents, it will not print the
>>> zeros (example $23.00). How do I get it to include the .00?

Reply to this Message