請看我昨天的回答，和你的問題一樣，介紹的比較詳細

https://www.wukong.com/question/6528188391324909827/

金額轉大寫，我們做財務的經常用得上。

如下圖，單元格C6求和並設定為貨幣。

單元格B6填入函式：=SUBSTITUTE(SUBSTITUTE(IF(C6<0,"負","")&TEXT(TRUNC(ABS(ROUND(C6,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(C6,2))),"",TEXT(RIGHT(TRUNC(ROUND(C6,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(C6,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(C6,2),3))=".",TEXT(RIGHT(ROUND(C6,2)),"[DBNum2]")&"分",IF(ROUND(C6,2)=0,"","整")),"零元零",""),"零元","零")

如果你的資料不在C6，替換一下就好了。