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

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.

Copy an empty cell.
Select your "numbers". EditPaste Special, check Add.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Larry" wrote in message
...
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.