阿拉伯数字转中文大写-准确到亿

suixin1976 · 发表于 2014-6-23 10:59:02

公式 =IF(TRUNC(A2)=0,"",NUMBERSTRING(TRUNC(A2),2)&"元"&IF(OR(CEILING(REPLACEB(RIGHT(FIXED(A2,2),4),2,1,"")/99,1)=1,CEILING(RIGHT(FIXED(A2,2),2)/9,1)=1),"零",""))&IF(LEFT(RIGHT(FIXED(A2,2),2),1)="0","",NUMBERSTRING(LEFT(RIGHT(FIXED(A2,2),2),1),2)&"角")&IF(RIGHT(FIXED(A2,2),1)="0","整",NUMBERSTRING(RIGHT(FIXED(A2,2),1),2)&"分")
其中A2就是有阿拉伯数字的单元格把公式放在要表达为中文大写的单元格