数字大小写转换公式问题
如图,在右边输入小写数字后,左边没有按照正确的大写格式显示出来!
这是公式(=SUBSTITUTE(SUBSTITUTE(IF(F22<0,"负","")&TEXT(TRUNC(ABS(ROUND(F22,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(F22,2))),"",TEXT(RIGHT(TRUNC(ROUND(F22,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(F22,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(F22,2),3))=".",TEXT(RIGHT(ROUND(F22,2)),"[DBNum2]")&"分",IF(ROUND(F22,2)=0,"","整")),"零元零",""),"零元",""))
创作者俱乐部成员