Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Mathematics (https://www.askmehelpdesk.com/forumdisplay.php?f=199)
-   -   Formula for converting 8 bit Hexadecimal into binaryi.e 32 bit in EXCEL. I mean if (https://www.askmehelpdesk.com/showthread.php?t=822638)

  • Mar 10, 2016, 08:39 AM
    chidayo
    Formula for converting 8 bit Hexadecimal into binaryi.e 32 bit in EXCEL. I mean if
    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
  • Mar 10, 2016, 08:48 AM
    ebaines
    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.