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

Excel does not accept text format! 0
Filter ZIP codes into ranges 6
Mail Merge Help 1
Problems created by Recent updates to Outlook 365 0
Format Zip Codes Correctly for a Mailmerge 3
Format Zip Codes in Excel for a Mailmerge 2
Need to format varying zip codes... 9
Entering Data In Form Field 2

Top