+ Reply to Thread
Results 1 to 2 of 2

Absolute Values

  1. #1
    lehigh46
    Guest

    Absolute Values

    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


  2. #2
    Bernie Deitrick
    Guest

    Re: 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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1