求教EXCEL转换大写的问题

来源：百度知道 编辑：UC知道 时间：2024/05/28 02:46:27
请教下 EXCEL转换大写的问题：
比如 我的小写是 ￥ 1 2 3 0 0 注意 最后两个0是指角和分，并且各个数字之间有空格，希望转换完就是 壹佰贰拾叁元整 希望高手回答哈 谢谢

SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(NUMBERSTRING(INT(A1),2)&"圆"&TEXT(MOD(A1,1)*100,"[dbnum2]0角0分"),"零角零分","整"),"零角","零"),"零分","")

补充一楼

如你把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分"),"零角零分","整"),"零角","零"),"零分","") 】中括号不要输入