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 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.
What you need to use is ABS(). This is the absolute value
function. If you click on the function wizard (the icon is a "fx), it
opens. The first function in the list should be ABS.
--Dan
--
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
