"Mikeopolo" wrote:
Or, if the values may already contain negatives,
and you want to retain those, if values start in A1, then type
=min(a1,-a1) into B1

Much neater, thanks !

and even the earlier
... B1: =A1*-1

should also be just B1: = -A1 <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---