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" wrote in message
...
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