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