Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Gamba Lisa
 
Posts: n/a
Default Zip codes that start with zero

I can format the cell as text in Excel and the zeros show up and print fine,
but when I mail merge into WORD, I get a zero ONLY as a zipcode. Frustrating.
I need to print labels by Friday. WHat do I do?
  #2   Report Post  
Ragdyer
 
Posts: n/a
Default

See if this link helps:

http://office.microsoft.com/enÂ*-ca/...4951033.Â*aspx
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Gamba Lisa" <Gamba wrote in message
...
I can format the cell as text in Excel and the zeros show up and print

fine,
but when I mail merge into WORD, I get a zero ONLY as a zipcode.

Frustrating.
I need to print labels by Friday. WHat do I do?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merge will not accept zip codes that start with a zero "label frustrated label maker Excel Discussion (Misc queries) 1 April 21st 05 09:03 PM
Cntrl find - cannot locate zip codes that start with zero. Possibl jjjJackieCalifornia Excel Discussion (Misc queries) 9 March 12th 05 08:27 PM
Printing zip codes that start with 0 ET13 Excel Discussion (Misc queries) 2 January 17th 05 12:13 AM
Printing zip codes that start with 0 ET13 Excel Discussion (Misc queries) 0 January 16th 05 11:47 PM
Inserting Blank Rows Macro? Michael Saffer Excel Worksheet Functions 2 November 9th 04 06:23 PM


All times are GMT +1. The time now is 09:21 AM.

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

About Us

"It's about Microsoft Excel"