convert negative decimals to positive
 

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

convert negative decimals to positive
 

<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

convert negative decimals to positive
 

Many thanks. Totally elementary i had dimmed the variable as long!!!

Sorry
--
with kind regards

Spike


"Niek Otten" wrote:

<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