Absolute Values

Tom,

You could do a Find and Replace of ABS with nothing. Of course, you wouldn't
be able to "turn it back on" after doing that.

HTH,
Bernie
MS Excel MVP


"lehigh46" <lehigh46@verizon.net> wrote in message
news:sc20c19lc18bf2qs72kim6ofi4k6v25m6i@4ax.com...
> Hi All
>
> Is it possible to turn off ALL absolute values on a work sheet with
> out changing each individual formula?
>
> Thanks for your help
>
>
> Tom Snyder
>
>
> x-- 100 Proof News - http://www.100ProofNews.com
> x-- 3,500+ Binary NewsGroups, and over 100,000 other groups
> x-- Access to over 1.6 Terabytes per Day - $8.95/Month
> x-- UNLIMITED DOWNLOAD
>

Tom,

You could do a Find and Replace of ABS with nothing. Of course, you wouldn't
be able to "turn it back on" after doing that.

HTH,
Bernie
MS Excel MVP


"lehigh46" <lehigh46@verizon.net> wrote in message
news:sc20c19lc18bf2qs72kim6ofi4k6v25m6i@4ax.com...
> Hi All
>
> Is it possible to turn off ALL absolute values on a work sheet with
> out changing each individual formula?
>
> Thanks for your help
>
>
> Tom Snyder
>
>
> x-- 100 Proof News - http://www.100ProofNews.com
> x-- 3,500+ Binary NewsGroups, and over 100,000 other groups
> x-- Access to over 1.6 Terabytes per Day - $8.95/Month
> x-- UNLIMITED DOWNLOAD
>

Hi All

Is it possible to turn off ALL absolute values on a work sheet with
out changing each individual formula?

Thanks for your help


Tom Snyder


x-- 100 Proof News - http://www.100ProofNews.com
x-- 3,500+ Binary NewsGroups, and over 100,000 other groups
x-- Access to over 1.6 Terabytes per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD

Tom,

You could do a Find and Replace of ABS with nothing. Of course, you wouldn't
be able to "turn it back on" after doing that.

HTH,
Bernie
MS Excel MVP


"lehigh46" <lehigh46@verizon.net> wrote in message
news:sc20c19lc18bf2qs72kim6ofi4k6v25m6i@4ax.com...
> Hi All
>
> Is it possible to turn off ALL absolute values on a work sheet with
> out changing each individual formula?
>
> Thanks for your help
>
>
> Tom Snyder
>
>
> x-- 100 Proof News - http://www.100ProofNews.com
> x-- 3,500+ Binary NewsGroups, and over 100,000 other groups
> x-- Access to over 1.6 Terabytes per Day - $8.95/Month
> x-- UNLIMITED DOWNLOAD
>