EXCEL表中将金额拆分成元角分格式的,即:A1是金额50000000,,如何做...答:,1))向右复制到P1 如果是转换大小写,在A2输入 =IF(OR(A1<=0,COUNTBLANK(A1)),"",TEXT(INT(A1),"[dbnum2]")&IF(INT(A1)=A1,"元整","元")&IF(INT(A1)=A1,"",TEXT(--RIGHT(INT(A1*10)),IF(--RIGHT(INT(A1*100))>0,"[=0]零;[dbnum2]#角","[dbnum2]#角;;;"...