A Andrea Jan 31, 2005 #1 I have column made up of formulas that I want to convert the formula to it's value. Is this an option in Excel
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 Robin Hammond Jan 31, 2005 #2 Copy the range, then edit, paste special, values. Robin Hammond www.enhanceddatasystems.com
R Rob van Gelder Jan 31, 2005 #3 Yes, Highlight the range of cell, select Copy. From the Edit menu, select Paste Special. Choose Values.
Yes, Highlight the range of cell, select Copy. From the Edit menu, select Paste Special. Choose Values.