货币大写转换函数的更新!

80酷酷网    80kuku.com

  大写|函数|货币|转换Function AtoC(a As Currency) As String
    '说明:本函数适合于万亿以下的货币转换,允许A的值是最多两位小数
    '定义两个字符串,此处汉字与数字均按一位计算
    Dim String1 As String   '如下定义
    Dim String2 As String   '如下定义
    Dim String3 As String   '从原A值中取出的值
    Dim I As Integer        '循环变量
    Dim J As Integer        'A的值乘以100的字符串长度
    Dim Ch1 As String       '数字的汉语读法
    Dim Ch2 As String       '数字位的汉字读法
    Dim nZero As Integer    '用来计算连续的非零数是几个
    
    String1 = "零壹贰叁肆伍陆柒捌玖"
    String2 = "万仟佰拾亿仟佰拾万仟佰拾元角分"
    'MsgBox CStr(a * 100)
    If InStr(1, CStr(a * 100), ".") <> 0 Then
        err.Raise 5000, , "此函数( AtoC() )只能转换小数点后有两位以内的数!"
    End If
    
    J = Len(CStr(a * 100))
    String2 = Right(String2, J)         '取出对应位数的STRING2的值
    
    For I = 1 To J
        String3 = Mid(a * 100, I, 1)    '取出需转换的某一位的值
        If String3 <> "0" Then
            Ch1 = Mid(String1, Val(String3) + 1, 1)
            Ch2 = Mid(String2, I, 1)
            nZero = nZero + 1           '表示本位不为零
        Else
            
            If nZero <> 0 Or I = J - 9 Or I = J - 5 Or I = J - 1 Then
                If Right(AtoC, 1) = "零" Then AtoC = Left(AtoC, Len(AtoC) - 1)
                Ch1 = "零"
            Else
                Ch1 = ""
            End If
                        
            '如果转换的数值需要扩大,那么需改动以下表达式 I 的值。
            If I = J - 10 Then
                Ch2 = "亿"
            ElseIf I = J - 6 Then
                If nZero <> 0 Then
                    Ch2 = "万"
'                    nZero = 0
                End If
            ElseIf I = J - 2 Then
                Ch2 = "元"
             ElseIf I = J Then
                Ch2 = "整"
            Else
                Ch2 = ""
            End If

分享到
  • 微信分享
  • 新浪微博
  • QQ好友
  • QQ空间
点击: