How do you convert a formula cell to a constant cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
After calculation, copy the cell with the formula then Edit - Paste Special -
Values on the same cell. HTH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I add a formula to a cell containing a constant value 2
How do I fix: cell won't calculate because it is a constant? 1
Formula vs. Constant 24
Excel VBA 1
Disabling automatic formula arguments 1
Formula won't display as cell set to Constant 1
how can we make one constant number to be act as variable 3
How to set text color based on value in cell compared to constant 3

Back
Top