『第
2 楼』:
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
|