-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 7/12/2012 1:53 PM, Doug wrote:
> On 07/12/2012 11:28 AM, Gilles wrote:
>> Hello
>>
>> A cell contains a negative number that I need to turn into a
positive, eg.
>> -123 becomes 123.
>>
>> I checked the Math section, but didn't find a function to d
On 07/12/2012 11:28 AM, Gilles wrote:
Hello
A cell contains a negative number that I need to turn into a positive, eg.
-123 becomes 123.
I checked the Math section, but didn't find a function to do this:
http://help.libreoffice.org/Calc/Mathematical_Functions
Is there a way?
Thank you.
--
V
fice-users] [3.5.3.2/Calc] Turn negative number into
positive?
Hello
A cell contains a negative number that I need to turn into a positive, eg.
-123 becomes 123.
I checked the Math section, but didn't find a function to do this:
http://help.libreoffice.org/Calc/Mathematical_Functions
Is ther
Gilles wrote:
Hello
A cell contains a negative number that I need to turn into a positive, eg.
-123 becomes 123.
I checked the Math section, but didn't find a function to do this:
http://help.libreoffice.org/Calc/Mathematical_Functions
Is there a way?
Thank you.
--
View this message in cont
ABS() is overkill, just use minus:
"=-B3"
:)
--
Cley Faye
http://cleyfaye.net
2012/7/12 Dries Feys
> ABS() ?
>
> Met vriendelijke groeten, Cordialement, Regards,
>
> *DRIES FEYS*
> *CORPORATE SERVICES* • *Senior Software Engineer*
>
>
> On 12 July 2012 17:28, Gilles wrote:
>
> > Hello
> >
>
ABS() ?
Met vriendelijke groeten, Cordialement, Regards,
*DRIES FEYS*
*CORPORATE SERVICES* • *Senior Software Engineer*
On 12 July 2012 17:28, Gilles wrote:
> Hello
>
> A cell contains a negative number that I need to turn into a positive, eg.
> -123 becomes 123.
>
> I checked the Math sectio
Hello
A cell contains a negative number that I need to turn into a positive, eg.
-123 becomes 123.
I checked the Math section, but didn't find a function to do this:
http://help.libreoffice.org/Calc/Mathematical_Functions
Is there a way?
Thank you.
--
View this message in context:
http://nab