|
补充一楼如你把A1中的数据在A3当中转换成大写则在A3中输入【 =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(NUMBERSTRING(INT(A1),2)&"圆"&TEXT(MOD(A1,1)*100,"[dbnum2]0角0分"),"零角零分","整"),"零角","零"),"零分","") 】中括号不要输入反之想把A3中的数据在A1当中转换成大写则在A3中输入【 =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(NUMBERSTRING(INT(A3),2)&"圆"&TEXT(MOD(A3,1)*100,"[dbnum2]0角0分"),"零角零分","整"),"零角","零"),"零分","") 】中括号不要输入再之想把B1中的数据在A3当中转换成大写则在A3中输入【 =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(NUMBERSTRING(INT(B1),2)&"圆"&TEXT(MOD(B1,1)*100,"[dbnum2]0角0分"),"零角零分","整"),"零角","零"),"零分","") 】中括号不要输入注意函数当中 A3\A1与B1的转换就没问题了 |
