=HEX2BIN(LEFT(A1))&HEX2BIN(MID(A1,2,2),8)&HEX2BIN(RIGHT(A1,2),8)
=SUMPRODUCT(--MID(A2,LEN(A2)+1-ROW(INDIRECT("1:"&LEN(A2))),1),(2^(ROW(INDIRECT("1:"&LEN(A2)))-1)))
hex转bin:超过10bit。十六进制的一位是二进制的四位,这样三位十六进制数就达到二进制的12位,走出了HEX2BIN的能力。为此需要将超过两位的十六进制数进行拆分才能转换。
bin转hex:超过10bit。
Remember that Excel has a numerical precision of 15 digits. If you want 28 digits, format the cell as Text or preface the string of digits with a single tick (e.g. '
) as a PrefixCharacter property.