I'm afraid that does keep the relationship between the numbers. If I convert
a -1 to a 1, the the difference between that number and another number is not
maintanined.

"raypayette" wrote:


Could the absolute function be of help?
=ABS(n)


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=570564