Numeric/absolute values in spreadsheets





The function for numeric value (absolute value)

If you need to get the numeric value of a number or expression, this is done with ABS() in both Excel and Calc.

For Microsoft Excel it looks like this:
Numeric values in cells in an Excel spreadsheet

For OpenOffice Calc it looks like this:
Numeric values in cells in a Calc spreadsheet


Excel function names in various languages

For some reason Microsoft has decided to have localized function names, so for non-English versions of Excel, you need to use the translated function names. This is as far as I have gotten, finding the localized function names for this chapter:

CatalanABS()
CzechABS()
DanishABS()
DutchABS()
EnglishABS()
FinnishITSEISARVO()
FrenchABS()
GalicianABS()
GermanABS()
HungarianABS()
ItalianABS()
NorwegianABS()
PolishMODUŁ.LICZBY()
Portuguese (BR)ABS()
Portuguese (PT)ABS()
RussianABS()
SpanishABS()
SwedishABS()
TurkishMUTLAK()