人民币填空

标签：RIGHT DBNum2 TEXT 填于 填空 人民币

问题：按人民币金额将大写数字填于空处

 

解决：

{=TEXTJOIN({"拾","万","千","百","拾","元","角"},,TEXT(LEFT(RIGHT("　"&ROUND($A2,2)*100,9-COLUMN(A:H))),"[DBNum2]0"))&"分"}

 

标签：RIGHT,DBNum2,TEXT,填于,填空,人民币
From： https://www.cnblogs.com/officeplayer/p/16608589.html