81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

HEX2BIN()

Description

Converts a signed hexadecimal number to signed binary format.

How To Use in Sheets

HEX2BIN(signed_hexadecimal_number, [significant_digits])

External Links

Google Sheet: Number Base Functions

ow 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 featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.