Excel functions / Math

DECIMAL function

Turns a number written in another base, as text, into an ordinary number.

Syntax

=DECIMAL(text, radix)

Arguments

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

  1. A base-36 code

    ABC
    1Code
    22N9C123456

    In C2: =DECIMAL(A2, 36) → 123456

    Try this example

  2. Hexadecimal

    ABC
    1Hex
    2FF255

    In C2: =DECIMAL(A2, 16) → 255

    Try this example

Common mistakes

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.

Translate a whole formula

Try DECIMAL in the playground

Related functions