View Single Post
  #1   Report Post  
Larry
 
Posts: n/a
Default 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.