Mail merge dollar values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PCOR - 02 Feb 2005 15:41 GMT

Hi
I am attemoting to merge an EXCEL file which contains a heading TOTAL
Under that total are dollar valaue such as 620.00 or 1234.34
My trouble is that the mail merge shows as 620(no 00) 1234.34 shows up OK
How do I add the 2 zeros when reequired
Thanks

Signature

Norton Professional 2004 says this email is clean...believe it

Reply to this Message

Doug Robbins - 02 Feb 2005 23:56 GMT

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

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

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> Hi
> I am attemoting to merge an EXCEL file which contains a heading TOTAL
> Under that total are dollar valaue such as 620.00 or 1234.34
> My trouble is that the mail merge shows as 620(no 00) 1234.34 shows up OK
> How do I add the 2 zeros when reequired
> Thanks

Reply to this Message

PCOR - 03 Feb 2005 00:51 GMT

Many thanks for putting me on the right track

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 7 lines]
>> How do I add the 2 zeros when reequired
>> Thanks

Reply to this Message