problem with zip codes and filter

J

Joe

I'm trying to sort a spreadsheet by zip code and some zips show as
"06901" and others show as "6901". When I sort for one I don't get
the other. I tried to manually put a "0" before the the "6901" code
and excel will not let me. Which is weird because it will allow it to
be imported from another program like that. Is there some way I can
format it to get the "0" to show in the column?
 
B

Bob I

Format cell as TEXT before you put in the zip code, or prepend it with
an apostrophe '
 

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

mixing zip with zip+4 and then sorting 2
simple sorting of zip codes 5
sort by zip code 2
Zip Code/Service Area help 2
How do I zip sort mailing list when I have 5 digit AND 9 digit zip 1
lining up 2 columns of zip codes 1
zip codes starting with 0 1
mail merge and zip codes 10

Top