H J,

Assume the values start in A2,

B2: = -Abs(A2)

and drag down as far as required.

For column B use any other convenient column.

Copy | PasteSpecial | Values the formla cells, either in situ or to replace
the original column A values.


---
Regards,
Norman



"jwoodruff77" wrote in message
...