向高手请教,EXCEL里面,大小写转换的函数,比如1234.00元,应该是壹仟贰佰...答:在A1单元格输入1234.00 B1输入公式 =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(A1),"[dbnum2]")&TEXT(MOD(A1,1)*100,"[dbnum2]圆0角0分"),"零角零分","整"),"零角","零"),"零分","整")
EXCEL表格中不同币种的大小写金额转换公式答:=LOOKUP(LEFT(A1,3),{"CNY","EUR","GBP","HKD","JPY","USD"},{"人民币","欧元","英镑","港币","日元","美元"})&TEXT(--MID(A1,4,LEN(A1)),"[DBNUM2]")&"整"或=LOOKUP(LEFT(A1,3),{"CNY","EUR","GBP","HKD","JPY","USD"},{"人民币","欧元","英镑","港币",...