I have a work sheet that does vlookup on the zipcode. We get data from our
corporate web. The zip code shows as general, and the zip code on the sheet
now are numbers. I've tried doing the 1 in a cell then copy, paste special
multiply, but it doesn't change them to numbers just text. I then try to
format as numbers but it doesn't work. The only way is to type the number
over itself. How can I fix this? I can't see any apostrophe in front of it.
But if there is, is there an easy way to remove it quickly over a bunch of
zip codes?

Hve you tried adding the formula =Value(A1) and copying down. This should
coerce the text to numbers. Once you have done that you can copy and paste
special to replace the formulas with their values...
--
HTH...

Jim Thomlinson


"John K" wrote:

> I have a work sheet that does vlookup on the zipcode. We get data from our
> corporate web. The zip code shows as general, and the zip code on the sheet
> now are numbers. I've tried doing the 1 in a cell then copy, paste special
> multiply, but it doesn't change them to numbers just text. I then try to
> format as numbers but it doesn't work. The only way is to type the number
> over itself. How can I fix this? I can't see any apostrophe in front of it.
> But if there is, is there an easy way to remove it quickly over a bunch of
> zip codes?

Hi John,
Try Data-Text to columns, if it doesn't work go to one cell edit it with F2
and see if you don't have any blank spaces if you have count it and then do
CTRL H (replace), type as many spaces as you counted, go to replace with
don't enter anything here and press enter.

"John K" wrote:

> I have a work sheet that does vlookup on the zipcode. We get data from our
> corporate web. The zip code shows as general, and the zip code on the sheet
> now are numbers. I've tried doing the 1 in a cell then copy, paste special
> multiply, but it doesn't change them to numbers just text. I then try to
> format as numbers but it doesn't work. The only way is to type the number
> over itself. How can I fix this? I can't see any apostrophe in front of it.
> But if there is, is there an easy way to remove it quickly over a bunch of
> zip codes?

When I turned on the transition keys I see a ^ in front of the number in the
formula bar. But I can't do a find and replace to remove it.

"Eduardo" wrote:

> Hi John,
> Try Data-Text to columns, if it doesn't work go to one cell edit it with F2
> and see if you don't have any blank spaces if you have count it and then do
> CTRL H (replace), type as many spaces as you counted, go to replace with
> don't enter anything here and press enter.
>
> "John K" wrote:
>
> > I have a work sheet that does vlookup on the zipcode. We get data from our
> > corporate web. The zip code shows as general, and the zip code on the sheet
> > now are numbers. I've tried doing the 1 in a cell then copy, paste special
> > multiply, but it doesn't change them to numbers just text. I then try to
> > format as numbers but it doesn't work. The only way is to type the number
> > over itself. How can I fix this? I can't see any apostrophe in front of it.
> > But if there is, is there an easy way to remove it quickly over a bunch of
> > zip codes?