View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
zmr325
 
Posts: n/a
Default How do I get rid of formulas?

Hello,

I am new to excel and I am trying to learn how to hide formulas once I have
the data entered into a cell. Here is my question if for instance lets say
that in column c i have data entered from 2 to 100 and then say something
changes and I have to add or subtract 10 from each of those cells. Before
what I was doing in a blank column off to the side I would simply use this
=c2+10 and then copy down to the end and then cut and paste those results in
the original column. I don't mind doing that if when i cut and paste the
fomulas aren't pasted with the number. I just want the cell to be a number
by itself. THank you and I hope this makes sense.

zmr325

p.s. does anybody have easy formulas for a weighted moving average and an
exponential moving average.