第1个回答 2012-04-17
excel 方法:要转换的数字放在A5单元格
="大写人民币:"&IF(TRUNC(A5)=0,"",TEXT(TRUNC(A5),"[DBNum2]G/通用格式")&"元")&IF(TRUNC(A5*10)-TRUNC(A5*10,-1)=0,"零",TEXT(TRUNC(A5*10)-TRUNC(A5*10,-1),"[DBNum2]G/通用格式")&"角")&IF(TRUNC(A5*100)-TRUNC(A5*100,-1)=0,"",TEXT(TRUNC(A5*100)-TRUNC(A5*100,-1),"[DBNum2]G/通用格式")&"分")&IF(TRUNC(A5*100)-TRUNC(A5*100,-1)=0,"整","")