问题:按人民币金额将大写数字填于空处
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiI0gTMx81dsQWZ4lmZf1GLlpXazVmcvwFciV2dsQXYtJ3bm9CX9s2RkBnVHFmb1clWvB3MaVnRtp1XlBXe0xCMy81dvRWYoNHLwEzX5xCMx8FesU2cfdGLwMzX0xiRGZkRGZ0Xy9GbvNGLpZTY1EmMZVDUSFTU4VFRR9Fd4VGdsYTMfVmepNHLrJXYtJXZ0F2dvwVZnFWbp1zczV2YvJHctM3cv1Ce-cmbw5SOxYzN5QWNmNjMxETZzgjMzYzXzUTMwgTM5EzLclDMyIDMy8CXn9Gbi9CXzV2Zh1WavwVbvNmLvR3YxUjLyM3Lc9CX6MHc0RHaiojIsJye.png)
解决:
{=TEXTJOIN({"拾","万","千","百","拾","元","角"},,TEXT(LEFT(RIGHT(" "&ROUND($A2,2)*100,9-COLUMN(A:H))),"[DBNum2]0"))&"分"}
问题:按人民币金额将大写数字填于空处
解决:
{=TEXTJOIN({"拾","万","千","百","拾","元","角"},,TEXT(LEFT(RIGHT(" "&ROUND($A2,2)*100,9-COLUMN(A:H))),"[DBNum2]0"))&"分"}