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

N

Nick Hodge

Prefix with a single apostrophe
(')

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you enter zip codes starting with 0 for a mail merge 2
Leading zero from Zip Code not print on Label Merge 6
Leading 0 in Mail Merge document 4
Format Zip Codes Correctly for a Mailmerge 3
Problem importing ZIP codes from Excel 2002 into Outlook 2003 cont 1
How to merge Excel address columns when some zips begin with zeros 4
leading zero not displaying 1
How to enter zip starting with 0 (zero) 10

Top