Ask Experts Questions for FREE Help !
Ask
    chidayo's Avatar
    chidayo Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Mar 10, 2016, 08:39 AM
    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
    ebaines's Avatar
    ebaines Posts: 12,131, Reputation: 1307
    Expert
    		  
    #2

    Mar 10, 2016, 08:48 AM
    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.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Formula for converting 32 bit Hexadecimal into decimal in EXCEL [ 23 Answers ]

Formula for converting 32 bit Hexadecimal into decimal in EXCEL. I required a formula in the mSEXCEL for cinverting IEEE-754 32bit hexadecimal floating point representation into decimal floating point.

28 bit or 48 bit LBA Hard Drive? [ 2 Answers ]

I was told that if I do a fresh install of the original Windows XP, I will create a 28 bit LBA hard drive, that cannot be changed to a 48 bit hard drive, even if I update XP to Service Pack 1, 2, or 3. After hours of reading, it is my understanding that 48 bit LBA hard drives are "manufactured"...

What is the 32 bit hexadecimal formula [ 2 Answers ]

what is the 32 bit hexadecimal value of 613.5625 to decimal?

A computer has 32-bit instructions and 12-bit addresses [ 3 Answers ]

A computer has 32-bit instructions and 12-bit addresses. Suppose there are 250 2-address instructions. How many 1-address instructions, if any can be formulated?Explain.

View more questions Search