How do I convert cell contents that are Hex to binary?

  • Thread starter Thread starter Guest
  • Start date Start date
You can loop through all the cells -

Sub ConvertColumnK()
On Error Resume Next
For Each cell In Range(Cells(1, 11), Cells(Rows.Count, 11))
cell.Value = CDbl("&H" & cell.Value)
Next
On Error GoTo 0
End Sub

In your post in Misc you said convert to Decimal. Hex2Bin converts to
binary.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Decimal fractions to binary and vice versa 1
how do I extract hex digits in a cell and convert to binary 3
Hex contents of a binary file 1
Which is the best MBOX Converter Tool different formats conversion? 4
How do i convert from HEX to BIN 3
convert decimal to 16 bit hex 3
Import binary file and convert to HEX data 2
Convert Binary to Hex 9

Back
Top