DECIMAL

Converts specified text representing a number in the specified base into a base 10 number.

Syntax

DECIMAL( Text text, Integer radix ) → Number

Parameters

text

Required. The value to convert.

radix

Required. The base of the value represented by text.

Remarks

The text argument can be any combination of alpha-numeric characters that are valid for the radix, and is not case sensitive. If text contains characters that do not belong to the radix, the function returns the #VALUE! error value. If text contains a value that cannot be represented as a decimal, the function returns the #NUM! error value.

The radix must be greater than or equal to 2 and less than or equal to 36. Otherwise the function returns the #NUM! error value.

Example

Formula

=DECIMAL("F0",16)
=DECIMAL(101,2)

See Also

Function Reference
BASE Function