| mCn=Inputbox ("请输入小写数字:","提示信息...","0.00") | | If IsNumeric(mCn) And mCn<>"" then | | Cn=MoneyCn(Abs(Trim(mCn))) | | MsgBox Abs(Trim(mCn))&Chr(10)&Cn, 64, "转换结果..." | | Else | | MsgBox "不是合理的人民币数字!", 64, "错误信息..." | | End If | | | | Function MoneyCn(Num) | | if Instr(1,""&Num,".")=0 then | | Num=Num&".00" | | end if | | pp=Instr(1,""&Num,".")-1 | | ll=len(Num) | | For i=1 to ll | | ss=Mid(Num,i,1) | | Select case ss | | case "." | | Result=Result&"元" | | case "0" | | Result=Result&"零" | | case "1" | | Result=Result&"壹" | | case "2" | | Result=Result&"贰" | | case "3" | | Result=Result&"叁" | | case "4" | | Result=Result&"肆" | | case "5" | | Result=Result&"伍" | | case "6" | | Result=Result&"陆" | | case "7" | | Result=Result&"柒" | | case "8" | | Result=Result&"捌" | | case "9" | | Result=Result&"玖" | | End Select | | mm=pp-i | | Select case mm | | case -5 | | Result=Result&"毫" | | case -4 | | Result=Result&"厘" | | case -3 | | Result=Result&"分" | | case -2 | | Result=Result&"角" | | case 1 | | Result=Result&"拾" | | case 2 | | Result=Result&"佰" | | case 3 | | Result=Result&"仟" | | case 4 | | Result=Result&"万" | | case 5 | | Result=Result&"拾" | | case 6 | | Result=Result&"佰" | | case 7 | | Result=Result&"仟" | | case 8 | | Result=Result&"亿" | | case 9 | | Result=Result&"拾" | | case 10 | | Result=Result&"佰" | | case 11 | | Result=Result&"仟" | | End Select | | Next | | Result=Replace(Result, "零仟", "零") | | Result=Replace(Result, "零佰", "零") | | Result=Replace(Result, "零拾", "零") | | Result=Replace(Result, "零零", "零") | | Result=Replace(Result, "零零", "零") | | Result=Replace(Result, "零零", "零") | | Result=Replace(Result, "零元", "元") | | Result=Replace(Result, "零角零分", "整") | | MoneyCn=Result | | End FunctionCOPY |
|