在EXCEL中如何将小写金额用函数转换成大写金额并分列

2024-11-17 19:47:45

推荐回答（3个）

回答1：

r2输入：
=(TEXT(MID(SUBSTITUTE(TEXT($Q2,"000.00"),".",""),COLUMN(A1),1),"[dbnum2]"))
右拉即可。

回答2：

="人民币"&IF(B3=INT(B3),NUMBERSTRING(INT(B3),2)&"元整",IF(B3*10=INT(B3*10),NUMBERSTRING(INT(B3),2)&"元"&NUMBERSTRING(INT(B3*10)-INT(B3)*10,2)&"角整",IF(ROUNDDOWN(B3*10-INT(B3)*10,0)=0,NUMBERSTRING(INT(B3),2)&"元零"&NUMBERSTRING(ROUND(B3*100-INT(B3*10)*10,0),2)&"分",NUMBERSTRING(INT(B3),2)&"元"&NUMBERSTRING(INT(B3*10)-INT(B3)*10,2)&"角"&NUMBERSTRING(ROUND(B3*100-INT(B3*10)*10,0),2)&"分")))

回答3：

R2输入：
=TEXT(MOD(INT($Q2/10^(3-COLUMN(A:A))),10),"[dbnum2]")，右拉下拉填充。