excel 金额自动转中文大写

分类: IT文章 • 2024-01-20 13:41:36

在C2插入函数计算

=IF(B2=0,"",IF(INT(B2),TEXT(TRUNC(B2),"[dbnum2]")&"元","")&IF(MOD(B2,1)=0,"整",IF(TRUNC(B2,1),IF(B2=TRUNC(B2,1),TEXT(LEFT(RIGHT(B2*100,2)),"[dbnum2]0角整"),TEXT(RIGHT(B2*100,2),"[dbnum2]0"&IF(LEFT(RIGHT(B2*100,2))="0","","角")&"0分")),TEXT(B2*100,"[dbnum2]0分"))))