大写金额转换(报销大写金额转换)

缺乏、安全感 2023-09-26 14:09 78阅读 0赞

## 10240大写金额怎么？10240大写金额怎么写 ##

壹萬零贰佰肆拾。

![大写金额转换(报销大写金额转换)\_大写金额转换(报销大写金额转换)][u_1279359251_1811078017_fm_26_fmt_auto]

## Excel数字小写金额转换汉字大写金额公式的设置方式是什么？ ##

公式如下：

=IF(ROUND(A1,2)=0,"",IF(A1=1,TEXT(INT(ROUND(ABS(A1),2)),"\[dbnum2\]")&"元","")&IF(VALUE(MID(RIGHT(TEXT((ABS(A1)\*100+100),"\#\#\#"),2),1,1))=0,IF(VALUE(RIGHT(TEXT(ABS(A1)\*100,"\#\#\#"),1))=0,"整",IF(ABS(A1)>=1,"零","")&TEXT(VALUE(RIGHT(TEXT(ABS(A1)\*100,"\#\#\#"),1)),"\[dbnum2\]")&"分"),IF(VALUE(RIGHT(TEXT(ABS(A1)\*100,"\#\#\#"),1))=0,TEXT(VALUE(MID(RIGHT(TEXT((ABS(A1)\*100+100),"\#\#\#"),2),1,1)),"\[dbnum2\]")&"角整",TEXT(VALUE(MID(RIGHT(TEXT((ABS(A1)\*100+100),"\#\#\#"),2),1,1)),"\[dbnum2\]")&"角"&TEXT(VALUE(RIGHT(TEXT(ABS(A1)\*100,"\#\#\#"),1)),"\[dbnum2\]")&"分")))

公式中A1为小写金额所在单元格，实际使用中只需将其替换为实际小写金额所在单元格即可，非常方便。

## 写一个方法，将输入后数字金额转换成汉字大写金额 ##

请问是电脑还是手机，如果是电脑可以安装QQ输入法，如：QQ五笔输入法，按键设置里面有一个便捷模式，可以快速输入数字金额，一并生成汉字大写金额。好方便的！public class no4 \{ public static void main(string\[\] args) \{ // 金额大小写转换 float money=2038.0f; int m1,m2,m3,m4,m5,m6,temp; temp = (int)(money\*100); system.out.println(money); m1 =temp%1000000/100000; m2 =temp%100000/10000; m3 =temp%10000/1000; m4 =temp%1000/100; m5 =temp%100/10; m6 =temp%10; char c1,c2,c3,c4,c5,c6; c1=transe(m1); c2=transe(m2); c3=transe(m3); c4=transe(m4); c5=transe(m5); c6=transe(m6); string str=""; if(m1!=0) \{ str+=c1+"千"; \} if(m2!=0) \{ str+=c2+"百"; \} if(m1!=0&&m2==0&&(m3!=0||m4!=0)) \{ str+="零"; \} if(m3!=0) \{ str+=c3+"十"; \} if(m2!=0&&m3==0&&m4!=0) \{ str+="零"; \} if(m4!=0) \{ str+=c4; \} str+="元"; if(m5 ==0&&m6 ==0) \{ str+="整"; \} if(m5!=0) \{ str+=c5+"角"; \} if(m5==0&&m6!=0) \{ str+="零"; \} if(m6!=0) \{ str+=c6+"分"; \} system.out.print(str+"\\n"); system.out.println(".........................."); \} public static char transe(int m) \{ char r=' '; switch (m) \{ case 0: r ='零'; break; case 1: r ='壹'; break; case 2: r ='贰'; break; case 3: r ='叁'; break; case 4: r ='肆'; break; case 5: r ='伍'; break; case 6: r ='陆'; break; case 7: r ='柒'; break; case 8: r ='捌'; break; case 9: r ='玖'; break; \} return r; \} \}

![大写金额转换(报销大写金额转换)\_大写金额转换(报销大写金额转换)\_02][02]

## 金额的中文大写转换。例如：12345.678转换为壹万贰千叁百肆拾伍元陆角柒分。(15分) ##

电子表格中金额大小写如何转换

格式-单元格-特殊

用java程序编译，例如：12345.678转换为壹万贰千叁百肆拾伍元陆角柒分。

/还有一些不是很理想的地方

public class Change \{

public String change(String m)\{

StringBuffer re=new StringBuffer("");

int i=0;

int j=0;

i=m.lastIndexOf(".");

if(i==-1) i=m.length();

String b=m.substring(0, i);

char\[\] c=b.toCharArray();

StringBuffer s=null;

for(i=c.length-1,j=0;i>=0;i--,j++)\{

s=new StringBuffer("");

if(i!=c.length-1 && c\[i+1\]!='0')

s.append(changeNum(c\[i\]));

if(c\[i\]!='0')\{

switch (j%4)\{

case 1:s.append("拾");break;

case 2:s.append("佰");break;

case 3:s.append("仟");break;

default :break;

if(j!=0 && j%8==0)

s.append("亿");

else if (j!=0 && j%4==0)\{

s.append("万");

re=s.append(re);

re.append("圆");

i=m.lastIndexOf(".");

String d=null;

if(i!=-1)\{

d=m.substring(i+1,m.length());

char\[\] e=d.toCharArray();

if(e.length==1)

if(e\[0\]!='0')

re.append("零").append(changeNum(e\[0\])).append("角").toString();

if(e.length==2)

if(e\[0\]!='0' || e\[1\]!='0')

re.append("零");

if(e\[0\]!='0')

re.append(changeNum(e\[0\])).append("角").toString();

if(e\[1\]!='0')

re.append(changeNum(e\[1\])).append("分").toString();

return re.toString();

public String changeNum(char c)\{

String\[\] n=\{"零","壹","贰","叁","肆","伍","陆","柒","捌","玖"\};

return n\[c-'0'\];

public static void main(String\[\] args) \{

Change c=new Change();

System.out.println(c.change("123456.78"));

[u_1279359251_1811078017_fm_26_fmt_auto]: https://img2.baidu.com/it/u=1279359251,1811078017&fm=26&fmt=auto
[02]: https://img2.baidu.com/it/u=3069600056,1912209472&fm=26&fmt=auto