Forum Discussion

z888888's avatar
z888888
Copper Contributor
Oct 10, 2019

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 values ​between the two ends)

1 Reply

  • z888888's avatar
    z888888
    Copper Contributor
    Found a solution
    = BASE(HEX2DEC(A1), 2)
    Need Office 2010 or above

Resources