This article describes the formula syntax and usage of the DECIMAL function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.
Converts a text representation of a number in a given base into a decimal number.
The DECIMAL function syntax has the following arguments.
- Text Required.
- Radix Required. Radix must be an integer.
- The string length of Text must be less than or equal to 255 characters.
- The Text argument can be any combination of alpha-numeric characters that are valid for the radix, and is not case sensitive.
- Excel supports a Text argument greater than or equal to 0 and less than 2^53. A text argument that resolves to a number greater than 2^53 may result in a loss of precision.
- Radix must be greater than or equal to 2 (binary, or base 2) and less than or equal to 36 (base 36).
A radix greater than 10 use the numeric values 0-9 and the letters A-Z as needed. For example, base 16 (hexadecimal) uses 0-9 and A-F, and base 36 uses 0-9 and A-Z.
- If either argument is outside its constraints, DECIMAL may return the #NUM! or #VALUE! error value.
The workbook below shows examples of this function. Inspect them, change existing formulas, or enter your own formulas to learn how the function works.
To work more in-depth with the example data in Excel, download the embedded workbook to your computer, and then open it in Excel.
Top of Page