Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
George George is offline
external usenet poster
 
Posts: 77
Default Formatting A Number In Mail Merge

Hi all,

I created a document in Word that I am combining with and address file from
Excel. I get what I am looking for, except for the Zip Code field. In
Excel, I have the field formatted as a Zip Code (leading zeros), but when it
is included in Word, the leading zeros are gone - which will make the post
office people very unhappy!

How can I get the Zip Codes to print correctly?

Thank you in advance,

George
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Formatting A Number In Mail Merge

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

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"George" wrote in message
...
Hi all,

I created a document in Word that I am combining with and address file

from
Excel. I get what I am looking for, except for the Zip Code field. In
Excel, I have the field formatted as a Zip Code (leading zeros), but when

it
is included in Word, the leading zeros are gone - which will make the post
office people very unhappy!

How can I get the Zip Codes to print correctly?

Thank you in advance,

George


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
Can't get Word 2003 to keep data file with mail merge main documen Yourcareercoach Mailmerge 9 August 10th 06 12:19 PM
Mail Merge Number Sequencing Alison Mailmerge 4 April 28th 06 01:03 PM
Mail Merge with Original Formatting? Bobbie @ NPH Mailmerge 1 March 23rd 06 04:57 AM
Keeping number formats (eg. 5.15%) in Excel/Word Mail Merge Ximena Mailmerge 2 July 8th 05 10:36 AM
How do I control date formatting in a Word Mail Merge? Ric McWaters Mailmerge 1 April 21st 05 04:23 PM


All times are GMT +1. The time now is 05:07 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"