[dba-Tech] Excel question

I believe Jon was right, highlight and copy the cell(s) that contant the
formula, then paste special and select 'values' 


Ed Tesiny
EdTesiny at oasas.state.ny.us 

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Lembit
Soobik
Sent: Tuesday, January 05, 2010 12:14 PM
To: Discussion of Hardware and Software issues
Subject: [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 

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com