[dba-Tech] Excel question

Max Wanadoo max.wanadoo at gmail.com
Tue Jan 5 13:07:10 CST 2010


Why not just type it in then - quicker than copy-n-paste?

Max


-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Tesiny, Ed
Sent: 05 January 2010 19:00
To: Discussion of Hardware and Software issues
Subject: Re: [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

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




More information about the dba-Tech mailing list