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 values between the two ends)
1 Reply
- z888888Copper ContributorFound a solution
= BASE(HEX2DEC(A1), 2)
Need Office 2010 or above