excel表格如何设置大写数字和阿拉伯数字一致答:转百度里网友的回答:假设人民币大写:71587.96 在B1 单元格 A1输入公式 =right(b1,len(b1)-find(":",b1,1))A2输入下面公式 =IF(ABS(A1)<0.005,"",IF(A1<0,"负",)&IF(INT(ABS(A1)),TEXT(INT(ABS(A1)),"[dbnum2]")&"元",)&IF(INT(ABS(A1)*10)-INT(ABS(A1))*10,...
excel表格里小写数字怎么转换成大写金额答:".",ROUND(A2,2))),"",TEXT(RIGHT(TRUNC(ROUND(A2,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(A2,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(A2,2),3))=".",TEXT(RIGHT(ROUND(A2,2)),"[DBNum2]")&"分","整")其中"A2"是数字格,即需要转换为大写的那格。