convert negative decimals to positive

[Spike]

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

[Niek Otten]

<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" <Spike@discussions.microsoft.com> wrote in message news:F087BC91-9162-4F60-AA6D-8A05AD19C411@microsoft.com...
> 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

[Spike]

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" <Spike@discussions.microsoft.com> wrote in message news:F087BC91-9162-4F60-AA6D-8A05AD19C411@microsoft.com...
> > 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
>
>
>