MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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