Thread: Changing column of numbers made of formulas to just numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
SimonCC
 
Posts: n/a
Default Changing column of numbers made of formulas to just numbers
Copy the column, then Paste Special with Values only over the same column.

-Simon

"CJ" wrote:

I have a column of numbers that is made from formulas. Is there a way to
keep those numbers and remove the formulas so that it is just a column of
numbers.
Reply With QuoteReply With Quote