problem with zip codes and filter

[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?

 

[Bob I]

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

 

[Joe]

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

that worked thanks!

 

[Bob I]

that worked thanks!

You're welcome, have a great day!