Home » Category » Microsoft Excel

Microsoft Excel: zip codes starting with 0

205| Thu, 22 May 2008 22:11:00 GMT| anonymous| Comments (1)
When doing a mail merge from excel to word zip codes starting with 0 (zero)
drop the first number "0" from the address. ie zip code 01560 prints out as
1560. How do I get all 5 numbers to show?

Keywords & Tags: zip, codes, starting, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/495118/
 
«« Prev - Next »» 1 helpful answers below.
An Excel way:
Format all your Zip Codes as Text.

A Word way:
Before you start the merge, Tools | Options | General. Place a check next to
Confirm merge at open.
Start the Merge.
When you go to pick the Data Source, a box will pop up. Pick wirksheets via
DDE.

tj

"Joe Mac" wrote:

> When doing a mail merge from excel to word zip codes starting with 0 (zero)
> drop the first number "0" from the address. ie zip code 01560 prints out as
> 1560. How do I get all 5 numbers to show?

tjtjjtjt | Thu, 22 May 2008 22:13:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories