"garfield-n-odie" wrote in message
...
=ABS(A1)

or

=IF(A1<0,-A1,A1)

or

=IF(A1=0,A1,-A1)




Oh, duh! I should have thought of the greater and less than symbols! :)

Thanks Garfield!