A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Word don't reconized zero infront of Zip Code



 
 
Thread Tools Display Modes
  #1  
Old June 8th, 2005, 03:21 PM
ljCharlie ljCharlie is offline
Experienced Member
 
First recorded activity by OfficeFrustration: Jun 2005
Posts: 48
Question Word don't reconized zero infront of Zip Code

I'm doing a mail merge in MS Word 2003 and the zipcode column has a zero infront of the 8 digit numbers, and MS Word automatically display that zipcode to be 0 and the other 8 digit numbers are gone. This is if the zipcode column is formated as text in Excel. If the zipcode column is formated as Zip Code + 4 in Excel then when mail merge in Word, the zero that is in front of the rest of the numbers got trimmed and only display 8 digita instead of 9 digit with the zero leading. How do I solve this problem?

Any help is appreciated.

ljCharlie
  #2  
Old June 9th, 2005, 08:42 PM
Doug Robbins
external usenet poster
 
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
"ljCharlie" wrote in message
.. .

I'm doing a mail merge in MS Word 2003 and the zipcode column has a zero
infront of the 8 digit numbers, and MS Word automatically display that
zipcode to be 0 and the other 8 digit numbers are gone. This is if the
zipcode column is formated as text in Excel. If the zipcode column is
formated as Zip Code + 4 in Excel then when mail merge in Word, the
zero that is in front of the rest of the numbers got trimmed and only
display 8 digita instead of 9 digit with the zero leading. How do I
solve this problem?

Any help is appreciated.

ljCharlie


--
ljCharlie



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Converted document from WordPerfect. New footnotes are not being. C Lowman General Discussion 1 January 26th, 2005 11:19 PM
Basic macros query - where are they assigned to? Bert Coules New Users 15 January 18th, 2005 01:28 PM
WordPerfect - copying formatting Morgan Page Layout 1 January 10th, 2005 06:00 PM
Macro that will add the file path & date to Word footnotes? Rich P General Discussion 2 December 15th, 2004 08:49 PM
How do I convert a cd in word perfect to microsoft word greylady General Discussion 1 November 23rd, 2004 08:03 PM


All times are GMT +1. The time now is 07:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.