Excel DECIMAL Function
Summary
The Excel DECIMAL function converts an alpha-numeric number into its decimal equivalent.
Purpose
Converts an alpha-numeric number to decimal
Return value
Decimal number
Syntax
=DECIMAL (number, radix)
Arguments
- number - A string of alpha-numeric characters.
- radix - A number within the range [2, 36] that represents the base of the number to be converted.
Usage notes
The input string must only contain valid alpha-numeric characters corresponding with the provided base (radix).
| Base | Alpha-Numeric Characters |
|---|---|
| binary | 0 - 1 |
| octal | 0 - 7 |
| decimal | 0 - 9 |
| hexidecimal | 0 - 9 and A - F |
