|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 10th, 2007, 07:16 PM
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
July 10th, 2007, 07:22 PM
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
July 10th, 2007, 07:22 PM
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
