[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