| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to limit the size of a number result in a cell? | Excel Discussion (Misc queries) | |||
| How do I enter formula that adds a range if less than a number or | Excel Worksheet Functions | |||
| Formula reads date as number | Excel Discussion (Misc queries) | |||
| formula that gives me a random number less than other number | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
