Home » Category » Microsoft Excel

Microsoft Excel: Zipcodes and Zeros with Office XP Mail Merge

205| Thu, 22 May 2008 23:21:00 GMT| anonymous| Comments (1)
I have a column of zips.

Some have a leading zero.

I have first fixed the column cellproperties to be GENERAL, and saved
the file.

Then I reformatted using CUSTOM 00000, and saved the file.

Next I go to WORD, set up a mail merge, and then edit recipents, and
the leading zero has disappeared, leaving me with a four digit zip
code.

Whats the fix

--
Message posted from http://www.ExcelForum.com/

Keywords & Tags: zipcodes, zeros, office, xp, mail, merge, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/495140/
 
«« Prev - Next »» 1 helpful answers below.
Use text formatted zip codes or do as follows

[In Word, after you have inserted the Merge fields, press Alt+F9, to view
the field codes.

In the field code for the Zip Code, you can add a switch to format the
number. For example:
{ MERGEFIELD "Zip" \# "00000" }

Press Alt+F9 again to hide the field codes, then view the merged data.]

Taken from a post by Debra Dalgleish

also see

http://www.mvps.org/dmcritchie/excel/join.htm#fixuszip5
--

Regards,

Peo Sjoblom

"Gary Donohue >" <<Gary.Donohue.10t82b...excelforum-nospam.com> wrote in
message news:Gary.Donohue.10t82b...excelforum-nospam.com...
> I have a column of zips.
> Some have a leading zero.
> I have first fixed the column cellproperties to be GENERAL, and saved
> the file.
> Then I reformatted using CUSTOM 00000, and saved the file.
> Next I go to WORD, set up a mail merge, and then edit recipents, and
> the leading zero has disappeared, leaving me with a four digit zip
> code.
> Whats the fix
>
> --
> Message posted from http://www.ExcelForum.com/
>

peo | Thu, 22 May 2008 23:23:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories