Converts a text representation of a number in a given base into a decimal number.
Syntax
DECIMAL(text, radix)Argument
textobligatoriskt
The text string to convert to decimal.
radixobligatoriskt
The base of the number system (between 2 and 36).
The DECIMAL function takes a string representing a number and a radix (base) to return the equivalent decimal value. It supports bases ranging from 2 to 36. This is the inverse operation of the BASE function.
=DECIMAL("FF", 16)→255Converts the hexadecimal value 'FF' to its decimal equivalent.
=DECIMAL("1011", 2)→11Converts the binary value '1011' to its decimal equivalent.
Enter the text
Type the number you wish to convert as a text string inside quotes.
Specify the radix
Provide the base of the input number, such as 2 for binary or 16 for hexadecimal.
The text string can be up to 255 characters long.