DECIMAL (convert number from any base into decimal)

<< Click to Display Table of Contents >>

DECIMAL (convert number from any base into decimal)

Syntax:

DECIMAL(Number, Base)

Description:

Converts a number from any base to decimal (base 10) – for example a binary number (base 2) or a hexadecimal number (base 16).

Number is the number to be converted.

Base is the base of the number. Only integers between 2 and 36 are allowed.

Compatibility notes:

Microsoft Excel supports this function only in version 2013 or later. In older versions, the function is unknown.

Example:

DECIMAL("00101010", 2) returns 42

DECIMAL("FF", 16) returns 255

See also:

BASE, BIN2DEC, HEX2DEC, OCT2DEC