convert formula to its value

A

Andrea

I have column made up of formulas that I want to convert
the formula to it's value. Is this an option in Excel
 
R

Rob van Gelder

Yes,

Highlight the range of cell, select Copy.
From the Edit menu, select Paste Special. Choose Values.
 
Top