Deteting only formulas

  • Thread starter Thread starter Roger Dodger
  • Start date Start date
R

Roger Dodger

Its me again.

Is there a way to delete the formula from a cell without deleting the number
that the formula created?

Example,
A1: =A2+1
A2: =3
A1 will return 4. Can I delete the formula and leave the number 4?

Thank in advance, I love this group.

Kevin
 
Roger,

that's known as fixing the values. Select cell A1 and click <copy>,
then right-click and select Paste Special. Click on Values, then OK
and then <Esc> or <enter>.

Hope this helps.

Pete
 
Pete,

You are awesome, Where did you learn so much about excel?

Kevin

Roger,

that's known as fixing the values. Select cell A1 and click <copy>,
then right-click and select Paste Special. Click on Values, then OK
and then <Esc> or <enter>.

Hope this helps.

Pete
 
Thanks for feeding back, Kevin.

I've been using Excel for about 10 years, and before that Quattro Pro,
so you pick up a few things ...

Pete
 
Thanks for feeding back, Kevin.

I've been using Excel for about 10 years, and before that Quattro Pro,
so you pick up a few things ...

Pete






- Show quoted text -
Click to expand...
You may like this macro that does all at once.

Sub formulastovalues()
With ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormulas)
..Formula = .Value
End With
End Sub
 
Back
Top