"nolenkw" wrote in message
...
"raypayette" wrote:


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

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.

If all you're interested in is the difference, then try
=A1-MIN(A:A)
or if you don't want the lowest number to be zero & actually want it
positive, try
=A1-MIN(A:A)+1
--
David Biddulph