Exce; 2000-Format zip codes

S

Susan

How would one format a cell to 0nly the first 5 numbers
listed in the zip code.
Example:
zip code listed in 98221-4788
I want the cell format to read 98221 only
Tips?
Sincerely,
Helpless
 
D

Dave Peterson

You've got some replies to your other post.
How would one format a cell to 0nly the first 5 numbers
listed in the zip code.
Example:
zip code listed in 98221-4788
I want the cell format to read 98221 only
Tips?
Sincerely,
Helpless
Click to expand...
 

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

formal cell - limit zip code to 5 digits 3
Format Zip Codes Correctly for a Mailmerge 3
format cells as zip code not working 3
How do you enter zip codes starting with 0 for a mail merge 2
Entering Data In Form Field 2
FormattingLost 2
Format>Cells>Special>Zip Code 5
Zip Code formatting problem 3

Top