I have a spreadsheet with over 650000 rows. If I do a "Paste Special..." on
a column to convert from Formulas to Values it takes over 20 minutes! Anyone
know how can I speed it up? I'm surprised because it was so quick (< 5 secs)
to copy and paste the Formula over all the rows and see the results in the
column.

Thanks,
Shaun