You could have a formula in B1 like =A1 and then overwrite the formula
with a manual value if you want to change it.

Hope this helps.

Pete

On Sep 25, 8:56 pm, K-Roq wrote:
Is there a way to program a cell to display a referenced cell UNLESS you
choose to override it with a manually inputed value? Thanks in advance