请问电子表格如何把小写金额在另一行显示大写金额答:EXCEL中数字小写换大写方法一:在单元格A2中输入小写数字123.12 B2处输入以下公式 =SUBSTITUTE(SUBSTITUTE(IF(A2<0,"负","")&TEXT(TRUNC(ABS(ROUND(A2,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(A2,2))),"",TEXT(RIGHT(TRUNC(ROUND(A2,2)*10)),"[DBNum2]"))&IF(ISERR(...
怎样设置excel表可以在输入小写金额的同时自动填充大写金额答:这个可以用函数公式做到,假如你的小写金额在a1单元格,=substitute(substitute(substitute(if(-rmb(a1,2),text(a1,";负")&text(int(abs(a1)+0.5%),"[dbnum2]g/通用格式元;;")&text(right(rmb(a1,2),2),"[dbnum2]0角0分;;整"),),"零角",if(a1^2<1,,"零")),"万",if(and(...