Re: [libreoffice-users] [3.5.3.2/Calc] Turn negative number into positive?

2012-07-12 Thread Steven Shelton
-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

Re: [libreoffice-users] [3.5.3.2/Calc] Turn negative number into positive?

2012-07-12 Thread Doug
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

Re: [libreoffice-users] [3.5.3.2/Calc] Turn negative number into positive?

2012-07-12 Thread chris
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

Re: [libreoffice-users] [3.5.3.2/Calc] Turn negative number into positive?

2012-07-12 Thread Dan
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

Re: [libreoffice-users] [3.5.3.2/Calc] Turn negative number into positive?

2012-07-12 Thread Gabriel Risterucci
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 > > >

Re: [libreoffice-users] [3.5.3.2/Calc] Turn negative number into positive?

2012-07-12 Thread Dries Feys
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

[libreoffice-users] [3.5.3.2/Calc] Turn negative number into positive?

2012-07-12 Thread Gilles
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