Converting a column from formula to value

Posted by Marty Spaulding on December 29, 2000 2:44 PM

How do I do this ?
I can do it manually by F2 and F9, but when I try to
select the whole column, it'll only change the first cell
selected.

Any help GREATLY appreciated ....

Posted by Marty Spaulding on December 29, 2000 2:46 PM

doesn't do ANYTHING .....

Posted by Dave on December 29, 2000 8:05 PM

Hi Marty

I'm a bit confused by you question as F2 will only allow you to edit within the cell and F9 will only force Excel recalculate. Yet it semms you want to replace formulas with their values.

The PasteSpecial as values certainly works for me. How are you doing it?

Dave

OzGrid Business Applications