View Single Post
  #2   Report Post  
sirknightly sirknightly is offline
Junior Member
 
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