[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