Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 24th 05, 07:35 PM
S_Suarez
 
Posts: n/a
Default How do I input zeroes in a zip code for a mail merge?

I am trying to do a mail merge for a mass mailing I need to do. I am trying
to input zeros in the zip codes that start with zero. When I type in the
zero, Excel automatically erases it. How can I input a zero without having
excel automatically erase it?

  #2   Report Post  
Old August 24th 05, 08:23 PM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2005
Location: Washington, DC
Posts: 16
Default

Suarez,

Change the format of the cell. Select the cells into which you are inputting your zip codes, Then click Format...Cells...Number. Click on "Custom" in the list and in the "Type:" field, enter 00000.

Knightly

Quote:
Originally Posted by S_Suarez
I am trying to do a mail merge for a mass mailing I need to do. I am trying
to input zeros in the zip codes that start with zero. When I type in the
zero, Excel automatically erases it. How can I input a zero without having
excel automatically erase it?
__________________
---
SirKnightly
  #3   Report Post  
Old December 9th 05, 04:58 PM posted to microsoft.public.excel.worksheet.functions
c_thonus
 
Posts: n/a
Default How do I input zeroes in a zip code for a mail merge?

If you already have your database typed with the zip codes formatted as
"Special Zip" and they appear in excel correct but are incorrect in word when
you do your mail merge, then save your worksheet as a .txt or "text" file.
Then use this as your database when doing your mail merge. The zeros should
be there.

"S_Suarez" wrote:

I am trying to do a mail merge for a mass mailing I need to do. I am trying
to input zeros in the zip codes that start with zero. When I type in the
zero, Excel automatically erases it. How can I input a zero without having
excel automatically erase it?



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
nine digit zip code won't print in mail merge Durham Excel Discussion (Misc queries) 11 July 1st 08 12:34 PM
Change case...help please Terry Excel Worksheet Functions 14 October 2nd 05 12:29 PM
Macro for changing text to Proper Case JPriest Excel Worksheet Functions 3 August 8th 05 09:31 PM
Using other workbooks.. DavidMunday Excel Worksheet Functions 2 July 1st 05 07:35 AM
Make Change Case in Excel a format rather than formula Kevin Excel Worksheet Functions 1 March 18th 05 09:53 PM


All times are GMT +1. The time now is 06:46 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017