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