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
|