在Excel函数公式里面怎么把一个数字变成大写的答:大写金额 = IIf(Left(Right(大写金额, 3), 1) = ";元", Left(大写金额, Len(大写金额) - 1) "角" Right(大写金额, 1) "分", IIf(Left(Right(大写金额, 2), 1) = "元", 大写金额 "角整", IIf(大写金额 = "零...
Excel中人民币大写怎么设置?答:公式为:=SUBSTITUTE(SUBSTITUTE(IF(A1<0,"负","")&TEXT(TRUNC(ABS(ROUND(A1,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(A1,2))),"",TEXT(RIGHT(TRUNC(ROUND(A1,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(A1,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(...