View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CJ
 
Posts: n/a
Default Changing column of numbers made of formulas to just numbers

That was so easy. Thanks for the help.

"SimonCC" wrote:

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.