Hi,
Sorry, but that isn't a realistic solution. This document will be used by a
large number of individuals/departments ... I cannot expect that they will
all be able to "remember" to do this ... however it does work and if it were
just me I would be satisfied with the answer. However, I see it as a bandaid
to my problem. I do appreciate your answer though.
Thank you.
"Dave Peterson" wrote:
Don't use the leading 0 when you're doing your find.
Excel is trying to find the value you type in. And if you look at the formula
bar with your leading 0 zipcode cell selected, you won't see that leading 0.
jjjJackieCalifornia wrote:
I have a large excel worksheet - zip codes, cities, states, area codes ... I
need to be able to sort as well as find. Problem comes in with states that
have zips starting with zero. I can get them to appear correctly as custom or
special, but not able to do cntrl-find and bring up ... I can't believe I
can't figure this out ...
--
Dave Peterson
|