how do i format zip codes that lead with a "0" in excel for a wor.

Guest · Feb 3, 2005

zip codes with leading zeros in excel won't merge in word mail merge

Nick Hodge · Feb 3, 2005

Prefix with a single apostrophe
(')

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)