Home |
Search |
Today's Posts |
#1
|
|||
|
|||
dropping leading zeros in mail merge
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? |
#2
|
|||
|
|||
Try putting quotes around the year. With quotes, the data is a string, not a
number. "Jim" wrote: 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? |
#3
|
|||
|
|||
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at http://www.gmayor.com/formatting_word_fields.htm -- 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 "Jim" wrote in message ... 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? |
#4
|
|||
|
|||
A simple number switch :
{Mergefield datefieldname \# "00"} should work -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Doug Robbins wrote: See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm Doug Robbins - Word MVP "Jim" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge shows blanks as zero's | Mailmerge | |||
Mail Merge dropping leading zeroes from the zip code | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
Trailing zeros cut off on mail merge from Excel | Mailmerge | |||
Leading spaces in Mail Merge field not printing | Mailmerge |