problem with zip codes and filter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 14 Mar 2008 18:06 GMT

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?

Reply to this Message

Bob I - 14 Mar 2008 18:27 GMT

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

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

Reply to this Message

Joe - 18 Mar 2008 13:33 GMT

> Format cell as TEXT before you put in the zip code, or prepend it with
> an apostrophe '
[quoted text clipped - 5 lines]
> > be imported from another program like that. Is there some way I can
> > format it to get the "0" to show in the column?

that worked thanks!

Reply to this Message

Bob I - 18 Mar 2008 14:50 GMT

>>Format cell as TEXT before you put in the zip code, or prepend it with
>>an apostrophe '
[quoted text clipped - 7 lines]
>
> that worked thanks!

You're welcome, have a great day!

Reply to this Message