[dba-Tech] Excel question

That works, John!
Thank you.
I think there was some command in 1-2-3 which did that, but I had never 
found it in Excel.
Great!
Lembit

----- Original Message ----- 
From: "Jon Tydda" <jon at tydda.plus.com>
To: "'Discussion of Hardware and Software issues'" 
<dba-tech at databaseadvisors.com>
Sent: Tuesday, January 05, 2010 7:30 PM
Subject: Re: [dba-Tech] Excel question


> 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
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com