"Norman Jones" wrote in message

Hi Arvi,

Will this not convert negative values to positive values?



It will. The OP needs to do an IF statement in a free column as
=IF(A1<0,A1*-1,A1) and then do a copy-paste special-values I think.