If I have an hexadecimal number as in 8 places e.g. 8E00AD01,
I want it converted into binary which will display as 32 bits using VBA
![]() |
If I have an hexadecimal number as in 8 places e.g. 8E00AD01,
I want it converted into binary which will display as 32 bits using VBA
Simply convert each hex digit into a 4-bit string. Pretty easy in using standard Excel formulas. Or you can use the "hex2bin" Excel function. Not sure about doing it in VBA.
All times are GMT -7. The time now is 01:09 AM. |