Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how will i convert 05.01.2007 convert 05.Jan.2007 format? | New Users to Excel | |||
convert number to its letters ( convert "1" to "One" ) | Excel Discussion (Misc queries) | |||
convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) |