View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Cindy B
 
Posts: n/a
Default 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