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". Edit>Paste Special, check Add.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Larry" <[email protected]> wrote in message
news:[email protected]...
> 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.