Question

在EXCEL中，如何将2012转为贰零壹贰？

纯数字转换就行，不是转换成金额！

Answer 1

选择自定义——自定义里输入贰零壹贰就可以了。

Answer 2

格式-单元格-数字-特殊-中文大写数字 

Answer 3

=IF(VALUE(LEFT(A1,1))=0,"零",CHOOSE(LEFT(A1,1),"壹","贰","叁","肆","伍","陆","柒","捌","玖"))&IF(VALUE(MID(A1,2,1))=0,"零",CHOOSE(MID(A1,2,1),"壹","贰","叁","肆","伍","陆","柒","捌","玖"))&IF(VALUE(MID(A1,3,1))=0,"零",CHOOSE(MID(A1,3,1),"壹","贰","叁","肆","伍","陆","柒","捌","玖"))&IF(VALUE(MID(A1,4,1))=0,"零",CHOOSE(MID(A1,4,1),"壹","贰","叁","肆","伍","陆","柒","捌","玖"))

办法是土了一点，但能用，呵呵

Answer 4

如果2012在A2单元格，公式如下：
=IF(ISERROR(FIND(".",A2)),NUMBERSTRING(INT(A2),2)&"元整",IF(ISERROR(NUMBERSTRING(MID(A2,FIND(".",A2)+2,1),2)),NUMBERSTRING(INT(A2),2)&"元"&NUMBERSTRING(MID(A2,FIND(".",A2)+1,1),2)&"角整",NUMBERSTRING(INT(A2),2)&"元"&NUMBERSTRING(MID(A2,FIND(".",A2)+1,1),2)&"角"&NUMBERSTRING(MID(A2,FIND(".",A2)+2,1),2)&"分"))

追问

不是金额，而日期

Answer 5

=TEXT(A1,"[DBNum2]")
假设数据在A1