怎样设置excel表可以在输入小写金额的同时自动填充大写金额答:B1=TEXT(INT(A1),"[dbnum2]")&"圆"&TEXT(--RIGHT(A1*100,2),"[dbnum2]0角0分")C1="大写:"&IF(TRIM(A1)="","",IF(A1=0,"","人民币"&IF(A1<0,"负",)&IF(INT(A1),TEXT(INT(ABS(A1)),"[dbnum2]")&"圆",)&IF(INT(ABS(A1)*10)-INT(ABS(A1))*10,TEXT(INT(...
EXCEL中用什么函数可以将例子中的阿拉伯数字转为大写数字答:在B1中输入或复制粘贴下列公式 =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,0,"零"),1,"壹"),2,"贰"),3,"叁"),4,"肆"),5,"伍"),6,"陆"),7,"柒"),8,"捌"),9,"玖")下拉填充 公式反复用SUBSTITUTE函数,依次将0-...
excel中如何把数字转换为人民币中文繁写答:如D为小写则把大写公式复制过去就行了,你可以把你的小写替代D8=IF(ROUND($D$8,2)<0,CONCATENATE("负",IF(ROUND(ABS($D$8),2)<1,"",TEXT(INT(ROUND(ABS($D$8),2)),"[dbnum2]")&"元")&IF(INT(ROUND(ABS($D$8),2)*10)-INT(ROUND(ABS($D$8),2))*10=0,IF(INT(ROUND...
如何才能在EXCEL表格中输入阿拉伯数字,同时在另一个格中显示为大写人民...答:=SUBSTITUTE(SUBSTITUTE(IF(-RMB(L42,2),TEXT(INT(ABS(A1)+0.5%),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(RMB(A1,2),2),"[dbnum2]0角0分;;整"),),"零角",IF(A1^2<1,,"零")),"零分","整")这个是我常用的.