dropping leading zeros in mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim - 16 Jun 2005 18:38 GMT

I use form letters for mailing to customers. Within the letters the model
year displays as a 2 digit year (98, 00). Everytime a vehicle year has
leading zeros the filed drops the leading zero. Editing the field and
telling ti to insert a zero is of no use as it adds the zero 98 also. This
was not an issue with office 2000 does anyone know how it can become not an
issue with 2003?

Reply to this Message

leftnotracks - 16 Jun 2005 23:02 GMT

Try putting quotes around the year. With quotes, the data is a string, not a
number.

> I use form letters for mailing to customers. Within the letters the model
> year displays as a 2 digit year (98, 00). Everytime a vehicle year has
> leading zeros the filed drops the leading zero. Editing the field and
> telling ti to insert a zero is of no use as it adds the zero 98 also. This
> was not an issue with office 2000 does anyone know how it can become not an
> issue with 2003?

Reply to this Message

Doug Robbins - 16 Jun 2005 23:46 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

>I use form letters for mailing to customers. Within the letters the model
> year displays as a 2 digit year (98, 00). Everytime a vehicle year has
[quoted text clipped - 4 lines]
> an
> issue with 2003?

Reply to this Message

Graham Mayor - 17 Jun 2005 07:02 GMT

A simple number switch :

{Mergefield datefieldname \# "00"}

should work

Signature

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

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

> See "Formatting Word fields with switches" on fellow MVP Graham
> Mayor's website at
[quoted text clipped - 10 lines]
>> not an
>> issue with 2003?

Reply to this Message

Rate this thread: