<< Click to Display Table of Contents >> DECIMAL (convert number from any base into decimal) |
Syntax:
DECIMAL(Number, Base)
Description:
This 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. The function is unknown in older versions.
Example:
DECIMAL("00101010", 2) returns 42
DECIMAL("FF", 16) returns 255
See also: