Hex2Bin

15/11/2007 - 13:01 von HarrieL | Report spam
Hello,
how can I convert a value more the 1FFh from Hex to bin, by using Excel2k3?
Im my case I need to convert numbers up to 3FF.
 

Lesen sie die antworten

#1 Frank Willberger
15/11/2007 - 13:47 | Warnen spam
HarrieL schrieb:
Hello,
how can I convert a value more the 1FFh from Hex to bin, by using Excel2k3?
Im my case I need to convert numbers up to 3FF.



Hello,

your number is in A1, then:

ÞC2BIN(INT(HEX2DEC(a1)/256))&TEXT(DEC2BIN(MOD(HEX2DEC(a1);256));"00000000")

goes up to ffff

hth

Frank

Ähnliche fragen