Forum Discussion
z888888
Oct 10, 2019Copper Contributor
HEX2BIN How to convert hexadecimal numbers over 511 to binary??
If I want to convert sixteen binary 2222 into binary 10 0010 0010 0010 in Excel, how to achieve? The Excel function HEX2BIN, why the valid value is limited to -512 to 511 (including the valid ...
z888888
Oct 10, 2019Copper Contributor
Found a solution
= BASE(HEX2DEC(A1), 2)
Need Office 2010 or above
= BASE(HEX2DEC(A1), 2)
Need Office 2010 or above