close
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
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 Colvinquot;STKquot; wrote:
gt; I imported data from a source. Now the numbers have a ' in front and leading
gt; zeros. How do I re-format to get rid of them?
gt; --
gt; STK
全站熱搜