| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do you convert a formula cell to a constant cell
I use a formula to calculate the value, such as time difference, and want to
save the value not the formula. The value (constant) will be used later to adjust both time cells used as arguments in the original formula--thus the need to preserve the value computed rather than the formula. |
|
#2
|
|||
|
|||
|
After calculation, copy the cell with the formula then Edit - Paste Special -
Values on the same cell. HTH "JQLogan" wrote: I use a formula to calculate the value, such as time difference, and want to save the value not the formula. The value (constant) will be used later to adjust both time cells used as arguments in the original formula--thus the need to preserve the value computed rather than the formula. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| How do I fix a formula in a cell? | Excel Discussion (Misc queries) | |||
| looking for a formula | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| How do I do math on a cell name in formula? | Excel Worksheet Functions | |||
Hybrid Mode
