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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()