[dba-Tech] Excel question

Lembit Soobik lembit.dbamail at t-online.de
Tue Jan 5 11:13:48 CST 2010


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 




More information about the dba-Tech mailing list