求助中文大写格式

hcm19522

C2:C11=IF(B2>0,"","负")&TEXT(INT(ABS(B2)),"[dbnum2]G/通用格式元;;")&TEXT(MID(B2,FIND(".",B2&".0")+1,1),"[dbnum2]G/通用格式角;;")&TEXT(MID(B2,FIND(".",B2&".00")+2,1),"[dbnum2]G/通用格式分")&"整"

D2:D11=IF(B2>0,"","负")&TEXT(ABS(B2/1%),"[dbnum2]"&RIGHT("0億0仟0百0拾0萬0仟0百0拾0元0角0分整",LEN(ABS(B2/1%))*2+1))

方式三 (規格固定)=IF(B2>0,"","负")&TEXT(ABS(B2/1%),"[dbnum2]0億0仟0百0拾0萬0仟0百0拾0元0角0分整")

sucx007

1. =TEXT(C12,"[$RMB][dbnum2]")

复制代码

,wps就用这个就好了