81% OFF online library of tutorials for mastering Google Sheets
HEX2BIN()
Description
How To Use in Sheets
HEX2BIN(signed_hexadecimal_number, [significant_digits])
External Links
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.