convert text-format number to number in excel 2000%3f

L

Larry

The number in the cells are formatted as text, how can I convert them back to
number quickly. There are around 5000 cells in Excel Spreadsheet of Version
2000.
I tried: Format, Cell, Number, F2, but the conversion is number by number
and it takes too long.
 
N

Niek Otten

Copy an empty cell.
Select your "numbers". Edit>Paste Special, check Add.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 
Top