You can create a mirror copy with help formulas and then copy it and paste
special as values,
I have done that with several thousands of records, to get a zip code
(assuming 5 digit) to text, use
=TEXT(Sheet1!A1,"00000")
then just drag copy across/down as long as needed, won't take long
finally just copy the help sheet and paste special as values in place or
over the old ones
--
Regards,
Peo Sjoblom
"jjjJackieCalifornia" wrote
in message ...
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
|