Exce; 2000-Format zip codes

  • Thread starter Thread starter Susan
  • Start date Start date
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
 
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...
 
Back
Top