How do i convert from HEX to BIN

A

Andersen

I know the form =HEX.TIL.BIN("c3";8)
But how can i convert a cell C3 and not the HEX c3
p.s. the 8 stands for how manny letters.
Kind regards Brian
 
N

Niek Otten

=HEX2BIN(C3,8) If C3 contains a 2 place HEX code
Apparently your language version is HEX.TIL.BIN, but I assume they function the same way

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I know the form =HEX.TIL.BIN("c3";8)
| But how can i convert a cell C3 and not the HEX c3
| p.s. the 8 stands for how manny letters.
| Kind regards Brian
 
A

Andersen

Thank you
In my language the code is =HEX.TIL.BIN(B3;8)

Kind regards.
Brian Andersen
 
A

Andersen

Now i have a new problem.
how can i be sure that it calculate in byte and not qword ?

Please help
 

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

Top