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.
|