方法一:;=IF(C15<0,"零元整",IF(C15=0,"",IF(TRUNC(C15)=C7,TEXT(TRUNC(C15),"[DBNum2][$-804]G/通用格式")&"元整",TEXT(TRUNC(C15),"[DBNum2][$-804]G/通用格式")&"元"&IF(TRUNC((C15)*10)-TRUNC(C15)*10=0,;"零"&TEXT(TRUNC((C15)*100)-TRUNC((C15)*10)*10,"[DBNum2][$-804]G/通用格式")&"分",TEXT(TRUNC((C15)*10)-TRUNC(C15)*10,"[DBNum2][$-804]G/通用格式")&"角"&IF(TRUNC((C15)*100)-TRUNC((C15)*10)*10=0,"整",TEXT(TRUNC((C15)*100)-TRUNC((C15)*10)*10,"[DBNum2][$-804]G/通用格式")&"分")))));把這些程式碼複製到你要輸出大寫金額的格內,;然後把C15改成你所要輸出的小寫金額的代號。;方法二:;右鍵點選需要轉換的阿拉伯數字單元格→選擇“設定單元格格式”→選擇“特殊”中的“中文大寫數字”型別→點選“確定”按鈕即可。詳見下圖:
方法一:;=IF(C15<0,"零元整",IF(C15=0,"",IF(TRUNC(C15)=C7,TEXT(TRUNC(C15),"[DBNum2][$-804]G/通用格式")&"元整",TEXT(TRUNC(C15),"[DBNum2][$-804]G/通用格式")&"元"&IF(TRUNC((C15)*10)-TRUNC(C15)*10=0,;"零"&TEXT(TRUNC((C15)*100)-TRUNC((C15)*10)*10,"[DBNum2][$-804]G/通用格式")&"分",TEXT(TRUNC((C15)*10)-TRUNC(C15)*10,"[DBNum2][$-804]G/通用格式")&"角"&IF(TRUNC((C15)*100)-TRUNC((C15)*10)*10=0,"整",TEXT(TRUNC((C15)*100)-TRUNC((C15)*10)*10,"[DBNum2][$-804]G/通用格式")&"分")))));把這些程式碼複製到你要輸出大寫金額的格內,;然後把C15改成你所要輸出的小寫金額的代號。;方法二:;右鍵點選需要轉換的阿拉伯數字單元格→選擇“設定單元格格式”→選擇“特殊”中的“中文大寫數字”型別→點選“確定”按鈕即可。詳見下圖: