Related Function:

The DECIMAL function converts a text representation of a number in a given base into a decimal number.

  • This function was introduced in Excel 2013 and so is not available in earlier versions.

Syntax

=DECIMAL(text,radix)

Arguments

Argument Description
text The text representation of the number that you want to convert

  text must be less than 256 characters long
radix The base, radix, of the supplied number

  radix must be an integer ≥ 2 and ≤ 36

Examples

  A B C D
1 Formula Result Notes How it works
2 =DECIMAL(“FF”,16) 255 Converts the hexadecimal (base 16) value FF to its equivalent decimal (base 10) value “F” is in position 15 in the base 16 number system. Because all number systems start with 0, the 16th character in hexadecimal will be in the 15th position
3 =DECIMAL(111,2) 7 Converts the binary (base 2) value 111 to its equivalent decimal (base 10) value “1” is in position 1 in the base 2 number system
4 =DECIMAL(“1100”,2) 12 Converts the binary (base 2) value 1100 to its equivalent decimal (base 10) value  
5 =DECIMAL(“70122”,8) 28754 Converts the binary (base 8) value 70122 to its equivalent decimal (base 10) value  

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if either:

  the supplied text argument is greater than 255 characters long
  the supplied radix argument is not recognized as a numeric value
#NUM! Occurs if either:

  the supplied radix argument is < 2 or > 36
  the supplied text argument is not recognized as a number in the specified base, radix