Cntrl find - cannot locate zip codes that start with zero. Possibl

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" <jjjJackieCalifornia@discussions.microsoft.com> wrote
in message news:CBED3874-8026-4624-B1F3-50A47A687E09@microsoft.com...
> 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
> >

Hi,
Thanks, but I need them formatted as numbers not text ...

"Peo Sjoblom" wrote:

> 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" <jjjJackieCalifornia@discussions.microsoft.com> wrote
> in message news:CBED3874-8026-4624-B1F3-50A47A687E09@microsoft.com...
> > 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
> > >
>
>
>