keep number when removing formula
 

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

keep number when removing formula
 

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" wrote in message
...
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

keep number when removing formula
 

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" wrote in message
...
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