How To Use DECIMAL()


The DECIMAL function converts the text representation of a number in another base, to base 10 (decimal).

Common questions about the DECIMAL formula are:
  • What specific data types can be used in the formula?
  • What is the syntax and usage of the DECIMAL formula?
  • How does the DECIMAL formula handle nonnumeric characters?

The DECIMAL formula can be used appropriately when converting numbers from one base to another, such as converting between binary, hexadecimal, and decimal.

The DECIMAL formula can be commonly mistyped by not including the correct conversion type or by not including the number to convert. Some mistypes include DECMAL, DECIML, DECIMLA, DCIMAL.

Some common ways the DECIMAL formula is used inappropriately include trying to use it to convert text strings that are not numeric, trying to convert numbers from one base to another without specifying the type of conversion, and using the formula to try to divide numbers.

Common pitfalls when using the DECIMAL formula include failing to specify the type of conversion required, mistyping the formula, and not setting the number of decimal places accurately.

Common mistakes when using the DECIMAL formula include not specifying the base of the input or the base of the output, not ensuring the number is correctly formatted, and failing to connect the input and output data types.

Common misconceptions people might have with the DECIMAL Formula include thinking that it will convert any type of text input, that it will convert any type of number into any other type of number, and that it is an all-purpose formula.

How To Actually Use DECIMAL() in Sheets

DECIMAL(value, base)

0Better Sheets Tutorials

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Find more formulas here at Better Sheets.

Learn more about the DECIMAL() formula:

Google Sheet: Number Base Functions

How to convert numbers between different number bases in Google Sheet. The video looks at the generic functions - DECIMAL and BASE which convert from any number base between 2 & 36 and decimal. The video focuses on conversions between the most common number bases using the functions DEC2BIN, DEC2OCT, DEC2HEX, HEX2DEC, OCT2DEC and BIN2DEC. The video demonstrates that Google Sheet can only add, subtract etc numbers in base 10 and shows how sometimes Google Sheet can give the incorrect impression that it can add and subtract numbers in other number bases. Finally the video looks at the maximum and minimum values allowed by each conversion.