Windows Forum

Ask something
Discussion Locked

Microsoft Excel

0 helpful
3 replies

by sbarnes

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Please give a simple explanation about using MS Word files transfered to MS Excel for mail merges. PROBLEM: zip codes beginning with "0" do not work. I went to various sites and got several formulas and they were very complicated and some did not work. Thanks

3 replies

by blackcurrant

The help files in Excel have a pile of information on using zip codes. Look up 'leading zero' or 'Zip code' and see what you get.

by cmb from omaha

Be sure to select the Zip Code column in Excel and then do "Format|Cells|Text". Do this before you attempt to do your mail merge in Word. Good luck.

This discussion is closed to new replies.