Absolute Values

L

lehigh46

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
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MARK EVERY FOURTH ROW 3
CALENDAR 3
Clock 1
Auto Filter 1
SEPERATE NUMBERS IN A CELL 8
SUMPRODUCT 1
FILE SHARING 1
Reversing rows of information 2

Top