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?