Hi,
I have just converted a range of numbers, that were stored as text, to number. I did this by clicking on the exlamation symbol, shown at the top of the selected range and then clicked "Convert to Number".
The range contained about 2200 cells and it has taken Excel 2007 almost a half hour to complete this operation. In Excel 2003 this was much faster.
I also tried multiplying by 1 (Paste special ...) and that only took about 1 second to complete.
Am I missing some setting which causes Excel 2007 to re-calculate the entire workbook after each conversion to number?
Any advise is appreciated.
Erwin
Bookmarks