Jon Tydda
jon at tydda.plus.com
Tue Jan 5 12:30:33 CST 2010
Except it won't. The problem with Excel is auto-calculation. Every time A7 changes, this cell will update to the present value. I'm not sure there's a way to do it without manually entering the data once it's there, or Copy/Paste Special Values. Jon -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: 05 January 2010 18:21 To: 'Discussion of Hardware and Software issues' Subject: Re: [dba-Tech] Excel question What about, If(A5=0,A5=A7) So it only takes the value once. Sommat like that. Max -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Lembit Soobik Sent: 05 January 2010 17:14 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