Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
#N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
replace absolute references | Excel Worksheet Functions | |||
How do I get absolute values for a range of cells? | Excel Discussion (Misc queries) | |||
Second serie doesn't use X-as values | Charts and Charting in Excel |