mail merge and zip codes
 

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!

mail merge and zip codes
 

In another column do text(A3,"00000") A3 being the cell with the zip and fill
down. then you should be able to copy the column and paste special values
over the old one.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"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!

mail merge and zip codes
 

okay so i know how to fill down, but i don't know what 'paste special values
over the old one' means...?

"John Bundy" wrote:

In another column do text(A3,"00000") A3 being the cell with the zip and fill
down. then you should be able to copy the column and paste special values
over the old one.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"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!

mail merge and zip codes
 

copy the column, then right click the top of the next column, select paste
special, then select values
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"LStout" wrote:

okay so i know how to fill down, but i don't know what 'paste special values
over the old one' means...?

"John Bundy" wrote:

In another column do text(A3,"00000") A3 being the cell with the zip and fill
down. then you should be able to copy the column and paste special values
over the old one.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"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!

mail merge and zip codes
 

copy which column, the one with the zip codes?
(thank you SO much!)

"John Bundy" wrote:

copy the column, then right click the top of the next column, select paste
special, then select values
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"LStout" wrote:

okay so i know how to fill down, but i don't know what 'paste special values
over the old one' means...?

"John Bundy" wrote:

In another column do text(A3,"00000") A3 being the cell with the zip and fill
down. then you should be able to copy the column and paste special values
over the old one.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"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!

mail merge and zip codes
 

Editpaste special as values


--
Regards,

Peo Sjoblom



"LStout" wrote in message
...
okay so i know how to fill down, but i don't know what 'paste special
values
over the old one' means...?

"John Bundy" wrote:

In another column do text(A3,"00000") A3 being the cell with the zip and
fill
down. then you should be able to copy the column and paste special values
over the old one.
--
-John
Please rate when your question is answered to help us and others know
what
is helpful.


"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!

mail merge and zip codes
 

Ok, say your unformatted zip codes are in column A insert a column between A
and B and in it put the code as before =Text(A3,"00000") assuming A3 is the
first cell with a zip, copy down. Now if these don't look right let me know
it failed on the first step. If it looks right select the column you just
made by clicking the header, this should select the entire column of
functions you just made, hit ctl-C to copy them. Now select the entire column
that contains your old zip codes, Column A in this scenario, select edit on
your toolbar, select 'Paste Special' then click the box with 'Values' the
zips you created should now be written over your old ones, delete the column
you created with all of the formulas. If this doesn't work you'll have to
send me your workbook and i'll do it for you when i get home.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"LStout" wrote:

copy which column, the one with the zip codes?
(thank you SO much!)

"John Bundy" wrote:

copy the column, then right click the top of the next column, select paste
special, then select values
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"LStout" wrote:

okay so i know how to fill down, but i don't know what 'paste special values
over the old one' means...?

"John Bundy" wrote:

In another column do text(A3,"00000") A3 being the cell with the zip and fill
down. then you should be able to copy the column and paste special values
over the old one.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"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!

mail merge and zip codes
 

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.

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

mail merge and zip codes
 

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!

mail merge and zip codes
 

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

mail merge and zip codes
 

Hi Dave,

Thank you very much for sharing your knowledge.

Challa Prabhu

"Dave Peterson" wrote:

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