<< 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: