DECIMAL()

Description

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

How To Use in Sheets

DECIMAL(value, base)

External Links

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.

0Better Sheets Tutorials

No videos yet. Stay tuned!