国产一区二区欧美精品免费-欧美国产日韩在线视频-欧美亚洲国语精品一区二区-欧美激情五月综合啪啪-国产69精品麻豆久久久久-亚洲人成精品久久久久桥网站-欧美刺激肥熟在线视频-十七岁日本免费完整版BD-黑夜在线拖拽不卡第一页

=SUBSTITUTE(SUBSTITUTE(IF(I138<0,"負","")&TEXT(TRUNC(ABS(ROUND(I138,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(I138,2))),"",TEXT(RIGHT(TRUNC(ROUND(I138,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(I138,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(I138,2),3))=".",TEXT(RIGHT(ROUND(I138,2)),"[DBNum2]")&"分",IF(ROUND(I138,2)=0,"","整")),"零元零",""),"零元","零")

就是這個格子自帶的公式，比如說15.2   我想要的事壹拾伍元貳角，但是會顯示壹拾伍元貳角整