如何在EXCEL表的单位格中把变数量变成金额,如12345.5元利用公式自动变成...答:b1=TEXT(INT(A1),"[dbnum2]")&IF(INT(A1)=A1,"元整","元")&IF(INT(A1)=A1,"",IF(MID(A1,LEN(A1)-1,1)=".",TEXT(RIGHT(A1,1)*1,"[dbnum2]")&"角",IF(AND(MID(A1,LEN(A1)-3,1)=".",MID(A1,LEN(A1)-1,1)<>"0"),TEXT(--MID(A1,LEN(A1)-1,1),"[dbnum...