ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do you convert a formula cell to a constant cell (https://www.excelbanter.com/excel-discussion-misc-queries/19666-how-do-you-convert-formula-cell-constant-cell.html)

JQLogan

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.

Michael

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.



All times are GMT +1. The time now is 06:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com