HEX2BIN How to convert hexadecimal numbers over 511 to binary？？

[z888888]

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)

[#2]

Found a solution
= BASE(HEX2DEC(A1), 2)
Need Office 2010 or above