Home » Category » Microsoft Excel

Microsoft Excel: Zip code with O as first digit

205| Wed, 04 Jun 2008 20:06:00 GMT| anonymous| Comments (2)
Help!
I'm trying to do an address label mail merge with Word
and Excel as the data source. I have zip codes that begin
with the number 0. I've formatted the cells in Excel
for "Zip Code", the correct format displays in the
spreadsheet but not in the merged document, the 0 is
missing.
Any thoughts, Thanks

Keywords & Tags: zip, code, first, digit, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/495095/
 
«« Prev - Next »» 2 helpful answers below.
After you select your Excel file as a data source, you should see a
'Confirm Data Source' dialog box. From that list, choose 'MS Excel
Worksheets via DDE (*.xls)', and your formatting will be retained.

If you connect through a different source, you can format the fields in
the Word document. For example, to specify a number of decimals:

1. In Word, in the Main Document, press Alt+F9 to view the field codes.
2. Find the field code for the zip code. It will look something like:
{ MERGEFIELD "Zip" }
3. Add a switch, to format the number. For example:
{ MERGEFIELD "Zip" \# "00000" }
4. Press Alt+F9 to hide the field codes.
5. Save the Main Document

CS wrote:
> Help!
> I'm trying to do an address label mail merge with Word
> and Excel as the data source. I have zip codes that begin
> with the number 0. I've formatted the cells in Excel
> for "Zip Code", the correct format displays in the
> spreadsheet but not in the merged document, the 0 is
> missing.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

debra | Wed, 04 Jun 2008 20:08:00 GMT |

or for those less oriented to MS Word you could format the
cells as text in Excel in the proper format beforehand.
with a macro see
http://www.mvps.org/dmcritchie/excel/join.htm#fixuszip5
then you will be using text and can handle zip, zip+5,
Canadian and other zip codes.
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Debra Dalgleish" <dsd...contexturesXSPAM.com> wrote in message news:4012CFA2.10607...contexturesXSPAM.com...
> After you select your Excel file as a data source, you should see a
> 'Confirm Data Source' dialog box. From that list, choose 'MS Excel
> Worksheets via DDE (*.xls)', and your formatting will be retained.
> If you connect through a different source, you can format the fields in
> the Word document. For example, to specify a number of decimals:
> 1. In Word, in the Main Document, press Alt+F9 to view the field codes.
> 2. Find the field code for the zip code. It will look something like:
> { MERGEFIELD "Zip" }
> 3. Add a switch, to format the number. For example:
> { MERGEFIELD "Zip" \# "00000" }
> 4. Press Alt+F9 to hide the field codes.
> 5. Save the Main Document
> CS wrote:
> > Help!
> > I'm trying to do an address label mail merge with Word
> > and Excel as the data source. I have zip codes that begin
> > with the number 0. I've formatted the cells in Excel
> > for "Zip Code", the correct format displays in the
> > spreadsheet but not in the merged document, the 0 is
> > missing.
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>

david | Wed, 04 Jun 2008 20:09:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories