Reply
 
Thread Tools Display Modes
  #1   Report Post  
Jim
 
Posts: n/a
Default 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   Report Post  
leftnotracks
 
Posts: n/a
Default

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   Report Post  
Doug Robbins
 
Posts: n/a
Default

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   Report Post  
Graham Mayor
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merge shows blanks as zero's gareth Mailmerge 1 June 9th 05 08:23 PM
Mail Merge dropping leading zeroes from the zip code lbradsha@erols Mailmerge 1 May 12th 05 04:50 PM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Trailing zeros cut off on mail merge from Excel alant Mailmerge 2 January 21st 05 01:45 AM
Leading spaces in Mail Merge field not printing Cindy M -WordMVP- Mailmerge 0 November 30th 04 05:25 PM


All times are GMT +1. The time now is 05:16 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"