Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi,
I am entering addresses into an Excel worksheet the I need to use in a mail merge. One of the addresses has a five digit postal zip code that begins with a "0" (zero.) I typed it in like any other zip code entry, but Excel dropped the zero as soon as I moved to the next cell. I tried converting the entry into "text," but when I printed the record, only the zero printed. Other zip codes that do not start with zero work fine in a mail merge and in printing the records. How can I enter a zip code that begins with a zero, so it will appear properly in Excel and in a mail merge? Thank you. Orrie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Enter doesnt return to the cell below the starting point anymore | Excel Discussion (Misc queries) | |||
Macro to select cells in column enter data then press enter | New Users to Excel | |||
How do you enter zip codes starting with 0 for a mail merge | Setting up and Configuration of Excel | |||
how do I enter a zipcode starting with a 0 | Excel Discussion (Misc queries) | |||
how do i enter numbers starting with zero in excel | Excel Discussion (Misc queries) |