1024.06 仟佰拾元角分 请在EXCEL里加上六个公式,能自动显示出 '壹...答:仟:=TEXT(MID(A1,1,1),"[dbnum2]0")佰:=TEXT(MID(A1,2,1),"[dbnum2]0")拾:=TEXT(MID(A1,3,1),"[dbnum2]0")元:=TEXT(MID(A1,4,1),"[dbnum2]0")角:=TEXT(MID(A1,6,1),"[dbnum2]0")分:=TEXT(MID(A1,7,1),"[dbnum2]0")...
Excel电子表格函数公式后面如何添加单位请教高手答:假设数字在a1,则 结果=IF(OR(A1="",A1=0),"",TEXT(INT(A1),"[dbnum2]")&IF(INT(A1)=A1,"元整","元")&IF(AND(INT(A1)<>A1,--RIGHT(INT(A1*10))=0),"零",TEXT(--RIGHT(INT(A1*10)),"[dbnum2]#角;;;"))&TEXT(--RIGHT(INT(A1*100))...