利用EXCEL函数进行财务数字大小写转换公式

通过 | 21 1 月, 2022

举例把$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]#分;;;")))

发表回复