keep number when removing formula

[Cindy B]

There must be a way to do this... How can I keep the NUMBER that is a result
of a formula - if I'm deleting the cells which are the sources of that
formula.
Appreciate ANY help you can send my way...

thanks -Cindy

--
Cindy B

[Ken Wright]

edit copy then edit paste special values

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Cindy B" <benedett@brainerd.net> wrote in message
news:7EC59B2E-2910-4781-8E44-428DF208E6D4@microsoft.com...
> There must be a way to do this... How can I keep the NUMBER that is a
> result
> of a formula - if I'm deleting the cells which are the sources of that
> formula.
> Appreciate ANY help you can send my way...
>
> thanks -Cindy
>
> --
> Cindy B

[Cindy B]

You are Awesome!!! Thanks for your help and quick reply!!!!
--
Cindy B


"Ken Wright" wrote:

> edit copy then edit paste special values
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ------------------------------Â*------------------------------Â*----------------
> It's easier to beg forgiveness than ask permission :-)
> ------------------------------Â*------------------------------Â*----------------
>
>
> "Cindy B" <benedett@brainerd.net> wrote in message
> news:7EC59B2E-2910-4781-8E44-428DF208E6D4@microsoft.com...
> > There must be a way to do this... How can I keep the NUMBER that is a
> > result
> > of a formula - if I'm deleting the cells which are the sources of that
> > formula.
> > Appreciate ANY help you can send my way...
> >
> > thanks -Cindy
> >
> > --
> > Cindy B
>
>
>