ABS() is overkill, just use minus: "=-B3" :)
-- Cley Faye http://cleyfaye.net 2012/7/12 Dries Feys <[email protected]> > ABS() ? > > Met vriendelijke groeten, Cordialement, Regards, > > *DRIES FEYS* > *CORPORATE SERVICES* • *Senior Software Engineer* > > > On 12 July 2012 17:28, Gilles <[email protected]> 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 context: > > > http://nabble.documentfoundation.org/3-5-3-2-Calc-Turn-negative-number-into-positive-tp3995113.html > > Sent from the Users mailing list archive at Nabble.com. > > > > -- > > For unsubscribe instructions e-mail to: > [email protected] > > Problems? > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > > List archive: http://listarchives.libreoffice.org/global/users/ > > All messages sent to this list will be publicly archived and cannot be > > deleted > > > > > > -- > DISCLAIMER **** > > http://www.tvh.com/newen2/emaildisclaimer/default.html > > "This message is delivered to all addressees subject to the conditions > set forth in the attached disclaimer, which is an integral part of this > message." > > -- > For unsubscribe instructions e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
