ExcelBanter - Excel Formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/67070-excel-formatting.html)

STK

Excel Formatting

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

Michael

Excel Formatting

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

All times are GMT +1. The time now is 02:07 PM.