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
|