Question

EXL中如何输入把阿拉伯数字自动转变成英文

按照网络中，ALT+11 复制内容设置模块，然后SPELLNUMBER(A1)但出来的结果还是#NAME? 该如何设置？

Answer 1

方法一：右键单元格，设置单元格格式－数字－特殊－中文大写数字
方法二：左键单元格，在上方输入栏输入以下文本=SUBSTITUTE(SUBSTITUTE(IF(A1<0,"负","")&TEXT(TRUNC(ABS(ROUND(A1,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(A1,2))),"",TEXT(RIGHT(TRUNC(ROUND(A1,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(A1,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(A1,2),3))=".",TEXT(RIGHT(ROUND(A1,2)),"[DBNum2]")&"分",IF(ROUND(A1,2)=0,"","整")),"零元零",""),"零元","")

追问

是把数字自动变成英文哦