举例把$C$5单元格的数字进行转换
公式如下：
=IF($C$5<=0,"",TEXT(INT($C$5),"[dbnum2]")&IF(INT($C$5)=$C$5,"元整","元")&IF(INT($C$5)=$C$5,"",TEXT(--RIGHT(INT($C$5*10)),IF(--RIGHT(INT($C$5*100))>0,"[=0]零;[dbnum2]#角","[dbnum2]#角;;;"))&TEXT(--RIGHT($C$5*100),"[dbnum2]#分;;;")))举例把$C$5单元格的数字进行转换
公式如下：
=IF($C$5<=0,"",TEXT(INT($C$5),"[dbnum2]")&IF(INT($C$5)=$C$5,"元整","元")&IF(INT($C$5)=$C$5,"",TEXT(--RIGHT(INT($C$5*10)),IF(--RIGHT(INT($C$5*100))>0,"[=0]零;[dbnum2]#角","[dbnum2]#角;;;"))&TEXT(--RIGHT($C$5*100),"[dbnum2]#分;;;")))