excel 小写数字转大写公式?

发布网友发布时间：2022-04-25 09:19

共2个回答

热心网友时间：2023-12-02 14:58

F7为参数，输入小写数字的单元格。公式如下
=IF(F7=0,"",IF(ABS(F7)<0.995,"",TEXT(INT(ROUND(ABS(F7),2)),"[DBNum2]")&"元")&IF(RIGHT(TEXT(F7,".00"),2)*1=0,IF(ABS(F7)<0.005,"","整"),TEXT(IF(ABS(F7)<0.095,"",LEFT(RIGHT(TEXT(F7,".00"),2))),"[dbnum2]")&IF(LEFT(RIGHT(TEXT(F7,".00"),2))*1=0,"","角")&IF(RIGHT(TEXT(F7,".00"))*1=0,"整",TEXT(RIGHT(TEXT(F7,".00")),"[dbnum2]")&"分")))

热心网友时间：2023-12-02 14:59

=SUBSTITUTE(TEXT(A1,"[DBNum2][$-804]G/通用格式"),".","点")

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com