DECIMAL FunctionWayne Becker20150925T23:13:15+00:00
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 
