❶ Excel 中如何把数字转换成中文大写金额，且有元角分
复制粘贴此公式，即可。=IF(TRUNC(O15)=0,"",TEXT(TRUNC(O15),"[DBNum2]G/通用格式")&"元")&IF(TRUNC(O15*10)-TRUNC(O15*10,-1)=0,IF(TRUNC(O15*100)-TRUNC(O15*100,-1)<>0,"零",""),TEXT(TRUNC(O15*10)-TRUNC(O15*10,-1),"[DBNum2]G/通用格式")&"角")&IF(TRUNC(O15*100)-TRUNC(O15*100,-1)=0,"",TEXT(TRUNC(O15*100)-TRUNC(O15*100,-1),"[DBNum2]G/通用格式")&"分")&IF(TRUNC(O15*100)-TRUNC(O15*100,-1)=0,"整","")
O15=（填写数字单元格）
