Lembit Soobik
lembit.dbamail at t-online.de
Tue Jan 5 15:59:52 CST 2010
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