How do i convert from HEX to BIN
 

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

How do i convert from HEX to BIN
 

=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


"Andersen" wrote in message ...
|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

How do i convert from HEX to BIN
 

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

Kind regards.
Brian Andersen


"Niek Otten" skrev i meddelelsen
...
=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


"Andersen" wrote in message
...
|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

How do i convert from HEX to BIN
 

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

Please help
"Andersen" skrev i meddelelsen
...
Thank you
In my language the code is =HEX.TIL.BIN(B3;8)

Kind regards.
Brian Andersen


"Niek Otten" skrev i meddelelsen
...
=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


"Andersen" wrote in message
...
|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