参考两个函数:将十进制数转换为二进制数:DEC2BIN(number, [places]),如:=DEC2BIN(9)=1001将二进制数转换为十进制数:BIN2DEC(number),如:=BIN2DEC(1100100)=100