Posted to microsoft.public.excel.misc

Joe

external usenet poster

Posts: 38

problem with zip codes and filter

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
problem in VB codes	peyman	Excel Discussion (Misc queries)	24	October 23rd 07 04:38 PM
problem in VB codes-2	peyman	Excel Discussion (Misc queries)	3	September 27th 07 09:07 PM
problem in VB codes	peyman	Excel Discussion (Misc queries)	5	September 27th 07 06:16 PM
filter problem	strictly_rhythm	Excel Discussion (Misc queries)	6	July 4th 06 12:24 PM
filter problem	strictly_rhythm	Excel Discussion (Misc queries)	1	July 3rd 06 09:49 PM

All times are GMT +1. The time now is 12:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us