| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i change a formula to its value
After a range has calculated the answer from a formula, how can I change the
same range to the value displayed? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i change a formula to its value
Select your range copy paste special values OK
"Davy" wrote: After a range has calculated the answer from a formula, how can I change the same range to the value displayed? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i change a formula to its value
Copy and paste special as values
-- Regards, Peo Sjoblom "Davy" wrote in message ... After a range has calculated the answer from a formula, how can I change the same range to the value displayed? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| want to copy formula, only change one number in formula | Excel Worksheet Functions | |||
| Formula change | Excel Discussion (Misc queries) | |||
| How does Data Validation change with a formula change? | Excel Worksheet Functions | |||
| how do I change "fx" in formula bar to "=" | Setting up and Configuration of Excel | |||
Linear Mode
