On Sep 11, 5:39*am, Pete_UK <pashu...@auditel.net> wrote:
> 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
>
> On Sep 11, 2:03*am, "Roger Dodger" <gtsmonaro...@bigpond.com> wrote:
>
>
>
> > Pete,
>
> > You are awesome, Where did you learn so much about excel?
>
> > Kevin
>
> > "Pete_UK" <pashu...@auditel.net> wrote in message
>
> >news:232c972b-7840-4d36-800c-(E-Mail Removed)...
> > 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
>
> > On Sep 11, 1:04 am, "Roger Dodger" <gtsmonaro...@bigpond.com> wrote:
>
> > > 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- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -
You may like this macro that does all at once.
Sub formulastovalues()
With ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormulas)
..Formula = .Value
End With
End Sub
|
Similar Threads
