大小写金额转换(电子表格大小写金额转换)

excel金额大小写怎么转换?1、比如输入，得出伍万肆仟柒佰叁?

  若输入数据在A1单元格内，则公式如下：

=IF(LEN(A1)=1,"零元零"&TEXT(A1,"[DBNum2]G/通用格式")&"分",IF(OR(RIGHT(A1,2)="00",RIGHT(A1,1)="0",MID(A1,LEN(A1)-1,1)="0"),TEXT(INT(A1/100),"[DBNum2]G/通用格式")&"元"&IF(RIGHT(A1,2)="00","整",IF(MID(A1,LEN(A1)-1,1)="0","零"&TEXT(RIGHT(A1,1),"[DBNum2]G/通用格式")&"分",TEXT(RIGHT(A1,2)/10,"[DBNum2]G/通用格式")&"角整")),TEXT(INT(A1/100),"[DBNum2]G/通用格式")&"元"&TEXT(INT(RIGHT(A1,2)/10),"[DBNum2]G/通用格式")&"角"&TEXT(RIGHT(A1,1),"[DBNum2]G/通用格式")&"分"))。

excel金额大小写怎么转换?1、比如输入，得出伍万肆仟柒佰叁?

  若输入数据在A1单元格内，则公式如下：

=IF(LEN(A1)=1,"零元零"&TEXT(A1,"[DBNum2]G/通用格式")&"分",IF(OR(RIGHT(A1,2)="00",RIGHT(A1,1)="0",MID(A1,LEN(A1)-1,1)="0"),TEXT(INT(A1/100),"[DBNum2]G/通用格式")&"元"&IF(RIGHT(A1,2)="00","整",IF(MID(A1,LEN(A1)-1,1)="0","零"&TEXT(RIGHT(A1,1),"[DBNum2]G/通用格式")&"分",TEXT(RIGHT(A1,2)/10,"[DBNum2]G/通用格式")&"角整")),TEXT(INT(A1/100),"[DBNum2]G/通用格式")&"元"&TEXT(INT(RIGHT(A1,2)/10),"[DBNum2]G/通用格式")&"角"&TEXT(RIGHT(A1,1),"[DBNum2]G/通用格式")&"分"))。

搜狗问问-搜狗旗下最大互动问答社区

搜狗问问-搜狗旗下最大互动问答社区