Also Zip code reformat

  • Thread starter Thread starter Dig
  • Start date Start date
D

Dig

Also is there a way to take the 9 zip code numbers and concert them to
zip+4? In other words I have a field that has just the straight 9 numbers
and I want them to be correctly formatted with the hyphen.

Thanks
 
<Format> <Cells> <Number> tab,
<Special> <ZipCode+4>
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
You must log in or register to reply here.

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

Turning a 9 digit string into zip+4 3
Excel 2007 is stupid dealing with zipcodes 2
How do I format zip code (9) to use in Word merg doc 1
Adding a HYPHEN to a 9 digit zip code column 7
How do I zip sort mailing list when I have 5 digit AND 9 digit zip 1
Zip Code formatting problem 3
Zip code filtering 1
format cells as zip code not working 3

Back
Top