keep number when removing formula

C

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
 
K

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 :)
------------------------------­------------------------------­----------------
 
Top