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?
|