[dba-Tech] Excel question

Lembit Soobik lembit.dbamail at t-online.de
Tue Jan 5 16:00:54 CST 2010


Could well be, Andy.....last time I used 123 was about 20 years ago  :)

Lembit

----- Original Message ----- 
From: "Andy Lacey" <andy at minstersystems.co.uk>
To: "'Discussion of Hardware and Software issues'" 
<dba-tech at databaseadvisors.com>
Sent: Tuesday, January 05, 2010 8:39 PM
Subject: Re: [dba-Tech] Excel question


> In 123 it was /Range Values IIRC.
>
> Andy
>
> -----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 19:26
> To: Discussion of Hardware and Software issues
> Subject: Re: [dba-Tech] Excel question
>
>
> Thanks, Ed,
> yes, that worked fine.
> Lembit
>
> ----- Original Message ----- 
> From: "Tesiny, Ed" <EdTesiny at oasas.state.ny.us>
> To: "Discussion of Hardware and Software issues"
> <dba-tech at databaseadvisors.com>
> Sent: Tuesday, January 05, 2010 8:00 PM
> 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
>
> _______________________________________________
> 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