Question

30369.52元转为大写怎么写？

Answer 1

公式：=CONCATENATE(IF(D2<0,"负",""),TEXT(IF(TRUNC(D2)=0,"零",TRUNC(ABS(D2))),"[DBNum2]")&"元",IF(OR(AND(ABS(D2)<0.1,TRUNC(D2)=D2),RIGHT(INT(ABS(D2)*100),2)="00"),"",TEXT(RIGHT(TRUNC(D2*10),1),"[DBNum2]")),IF(RIGHT(TRUNC(D2*10),1)="0","","角"),IF(OR(TRUNC(D2*10)-(D2*10)=0,RIGHT(TRUNC(D2*100),1)="0"),"整",TEXT(RIGHT(TRUNC(D2*100),1),"[DBNum2]")&"分"))

如果小写在其他单元格，替换公式中的D2即可

Answer 2

30369.52元转为大写------叁万零叁佰陆拾玖元伍角贰分

Answer 3

叁万零叁佰陆拾玖元伍角贰分

Answer 4

30369.52元
叁万零叁佰陆拾玖元伍角贰分