[dba-Tech] Excel question

gotcha..
wasnt that a fine approach to find out what you think of me... :) - he, who 
knows nothing...

Lembit

----- Original Message ----- 
From: "Max Wanadoo" <max.wanadoo at gmail.com>
To: "'Discussion of Hardware and Software issues'" 
<dba-tech at databaseadvisors.com>
Sent: Tuesday, January 05, 2010 11:06 PM
Subject: Re: [dba-Tech] Excel question


> Ha ha!
>
> I prefer the one above it....
>
> Another suggestion has been that Tonto, (whose name means "stupid" 
> according
> to some interpretations) responded by calling the Lone Ranger "qui no 
> sabe"
> which roughly translates from Spanish as "he who knows nothing" or
> "clueless."
>
>
> 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 22:00
> To: Discussion of Hardware and Software issues
> Subject: Re: [dba-Tech] Excel question
>
> ahaaa,
> so you think that old German guy doesn't understand Indian dialects?
> ;-)
> Lone Ranger looking in an Indian dictionary and discovering that kemosabe 
> is
>
> "an Apache expression for a horse's rear end."
> http://www.write101.com/kemosabe.htm
>
> good night
> Lembit
>
> ----- Original Message ----- 
> From: "Max Wanadoo" <max.wanadoo at gmail.com>
> To: "'Discussion of Hardware and Software issues'"
> <dba-tech at databaseadvisors.com>
> Sent: Tuesday, January 05, 2010 8:26 PM
> Subject: Re: [dba-Tech] Excel question
>
>
>> Ah so!
>>
>> Now I understand, Kemo Saby...
>>
>> 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 19:25
>> To: Discussion of Hardware and Software issues
>> Subject: Re: [dba-Tech] Excel question
>>
>> Max,
>> Great idea, but there a many places with 8 and more digits, and retyping
>> is
>> the safest way to get errors in.
>> Lembit
>> ----- Original Message ----- 
>> From: "Max Wanadoo" <max.wanadoo at gmail.com>
>> To: "'Discussion of Hardware and Software issues'"
>> <dba-tech at databaseadvisors.com>
>> Sent: Tuesday, January 05, 2010 8:07 PM
>> Subject: Re: [dba-Tech] Excel question
>>
>>
>>> 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
>>>
>>> _______________________________________________
>>> 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
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com