<you loose the decimals

You shouldn't. Maybe a question formatting, or just widen the column.

Another way: =ABS(A1)

--
Kind regards,

Niek Otten

"Spike" wrote in message ...
grateful for any advices on converting negative numbers with decimals to
positive; if you multiply by -1 you loose the decimals (well i do!)
--
with kind regards

Spike