Excel Formatting

S

STK

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?
 
M

Michael

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
 
Top