Getting rid of the formula but keep the Value

  • Thread starter Thread starter Nathan
  • Start date Start date
N

Nathan

I have created a PRODUCT formula linked with certain cells
and inputed the values elsewhere on the spreadsheet.

However, whenever I cut and paste the values on another
worsksheet or program, the formula shows up and not the
value. Is there a way to keep the value when transferring
it to another location?
 
There's a "paste special" command. Tick off 'values'
instead of all and you'll get just the value. I think
that's what you're looking for.

The other issue might be if you are copying and pasting a
formula that you still wish to have calculate something.
In that case, you are probably missing the "=" before the
formula in your destination cell.

Ross.
 
Back
Top