switches

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JHelfrich - 01 Oct 2004 21:09 GMT

I am having trouble formatting a date field and a currency field. In a merge
I am using excel. The "datepledged" field is merged "10/1/04" and I need it
to read October 1, 2004. And the "amountpledged" field comes in as 100 and I
need it to read $100.00. I usually format my letters in Access just because
of this....but I would love to be able to figure this out.

Signature

JHelfrich

Reply to this Message

melissa1005 - 02 Oct 2004 01:23 GMT

the date field switch is @\ "MMMM d, yyyy" and the currency switch is #\
$,#.00 use it inside the field after the field name.

>I am having trouble formatting a date field and a currency field. In a
>merge
[quoted text clipped - 5 lines]
> because
> of this....but I would love to be able to figure this out.

Reply to this Message

Doug Robbins - 02 Oct 2004 02:51 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

>I am having trouble formatting a date field and a currency field. In a
>merge
[quoted text clipped - 5 lines]
> because
> of this....but I would love to be able to figure this out.

Reply to this Message