G Guest Jan 28, 2005 #1 I converted my data to labels. I can't get the first 0 in the zip code does not show or print.
G gls858 Jan 28, 2005 #2 Judy said: I converted my data to labels. I can't get the first 0 in the zip code does not show or print. Click to expand... The field need to be formatted as text to get the leading zero to show. There may be other ways to do it but this will work. gls858
Judy said: I converted my data to labels. I can't get the first 0 in the zip code does not show or print. Click to expand... The field need to be formatted as text to get the leading zero to show. There may be other ways to do it but this will work. gls858
D David McRitchie Feb 2, 2005 #3 Hi Judy, and if you want to correct existing entries that lost the leading zero because you didn't have text already turned on, you can correct them with a macro http://www.mvps.org/dmcritchie/excel/join.htm#fixUSzip5 If not familiar with installing and using macros the box at the top of that page points to http://www.mvps.org/dmcritchie/excel/getstarted.htm
Hi Judy, and if you want to correct existing entries that lost the leading zero because you didn't have text already turned on, you can correct them with a macro http://www.mvps.org/dmcritchie/excel/join.htm#fixUSzip5 If not familiar with installing and using macros the box at the top of that page points to http://www.mvps.org/dmcritchie/excel/getstarted.htm
