Excel functions / Math
DECIMAL function
Turns a number written in another base, as text, into an ordinary number.
Syntax
=DECIMAL(text, radix)
Arguments
text: The digits, such as "FF".radix: The base they are written in, from 2 to 36.
When to use it
DECIMAL reads a number written in any base from 2 to 36 and gives it as an ordinary number. It is the inverse of BASE.
Examples
A base-36 code
A B C 1 Code 2 2N9C 123456 In C2:
=DECIMAL(A2, 36)→ 123456Hexadecimal
A B C 1 Hex 2 FF 255 In C2:
=DECIMAL(A2, 16)→ 255
Common mistakes
- Digits the base does not have. DECIMAL("19", 8) is #NUM!: base 8 has no 9.
DECIMAL in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: DECIMAL
- Danish: DECIMAL
- Dutch: DECIMAAL
- Finnish: DESIMAALI
- French: DECIMAL
- German: DEZIMAL
- Hungarian: TIZEDES
- Italian: DECIMALE
- Norwegian: DESIMAL
- Polish: DZIESIĘTNA
- Portuguese (Brazil): DECIMAL
- Portuguese (Portugal): DECIMAL
- Russian: ДЕС
- Spanish: CONV.DECIMAL
- Swedish: DECIMAL
- Turkish: ONDALIK