hi
you can't. entering a value would overwrite the formula.
you could do somthing like this..
=A1+A2 & 500 but that would turn the entire cell value to text and the
formula and value would be useless not to mention a waiste of time.

regards
FSt1

"Zapatera" wrote:

How can I enter a value in a cell that contains a formula but without erasing
the formula?