天天看点

人民币填空

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

人民币填空

解决:

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