Hi STK. in a helper column, say B, assuming your data is in A, in B1 type
=VALUE(A1) and copy down. Then copy column B and paste special-values over
column A. HTH
--
Sincerely, Michael Colvin


"STK" wrote:

I imported data from a source. Now the numbers have a ' in front and leading
zeros. How do I re-format to get rid of them?
--
STK