I have a sheet that contains various functions which is updated
regularly. The problem is, when updating, the formula never needs to
be changed, only the number. I know it is possible to simply edit the
number in the formula bar, but I was wondering if there was a way to
"append" a formula to a certain cell, allowing the user to simply type
in the number as they would a regular cell and not have to worry about
altering the formula.


Is this possible, or is it necessary to edit the number via the
formula bar each time?