[dba-Tech] Excel question

Hi, and Happy New Year,

I cannot find the following function in Excel:
I have a formula in one cell and want to convert it to the present value.
example:
A5 contains formula =A7
A7 contains 500 therefore I see 500 in A5
I need to do something with A5 so that it contains 500 even if I change A7 
to 0
no, I do not want to retype 500 into A5.

thanks
Lembit