If the values in that column were numbers with a custom format to show leading
0's, then this won't keep those leading 0's.

challa prabhu wrote:

Hi,

Do the following:

1. Select the cell, which would contain zip code.
2. Do one of the following:
* Right-click and select Format Cells.
* On the Format menu, click Cells.
The Format Cells dialog is displayed.
3. Click the Number Tab.
4. Under the Category list select Text.
5. Click OK to return to the Worksheet.

Challa Prabhu

"LStout" wrote:

i have a large mailing list in excell, and everytime i try to mail merge it
into word, it leaves out the first 0 (zero) in all of my zip codes. i have
the column setting set to "zip code" and it still drops the first 0. this is
going to take much too long to type in all of the 0's myself. is there a way
to fix this? thanks!

--

Dave Peterson