现成代码“人民币大小写转换程序.vbs”
- 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 Function
复制代码
[ 本帖最后由 fastslz 于 2008-6-20 14:57 编辑 ] |