excel有没有公式可以把小写阿拉伯数字转换成中文大写数字。

显示全部楼层 · 2011-7-9 17:47:12

比如，在A1单元格输入数字01，在B2单元格自动生成零壹，多谢了

千问 · 2011-7-9 17:47:12

三个公式，任你选=SUBSTITUTE(SUBSTITUTE(IF(A1>-0.5%,,"负")&TEXT(INT(ABS(A1)+0.5%),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(FIXED(A1),2),"[dbnum2]0角0分;;"&IF(ABS(A1)>1%,"整",)),"零角",IF(ABS(A1)<1,,"零")),"零分","整")=IF(ABS(a1)<0.005,"",IF(a1<0,"负",)&IF(INT(ABS(a1)),TEXT(INT(ABS(a1)),"[dbnum2]")&"元",)&IF(INT(ABS(a1)*10)-INT(ABS(a1))*10,TEXT(INT(ABS(a1...

千问 · 2011-7-9 17:47:12

=TEXT(A1,"[dbnum2]"&REPT(0,LEN(A1)))...

千问 · 2011-7-9 17:47:12

static string ConvertToChinese(double x)
{
string s = x.ToString("#L#E#D#C#K#E#D#C#J#E#D#C#I#E#D#C#H#E#D#C#G#E#D#C#F#E#D#C#.0B0A");
string d = Re...