加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 大数据 > 正文

VB实现数字到中文金额的转换函数

发布时间:2020-12-16 23:10:01 所属栏目:大数据 来源:网络整理
导读:Private Function NMoneyToSMoney ( NMoney As Variant ) As String If IsNumeric ( NMoney ) = False Then NMoneyToSMoney = "不是数字类型" Exit Function End If Dim BasicDWString As String,BasicDW ( ) As String Dim MoneyDWString As String,MoneyDW
Private Function NMoneyToSMoney ( NMoney As Variant )   As String
      If IsNumeric ( NMoney )     =   False Then
            NMoneyToSMoney   =   "不是数字类型"
            Exit Function
      End If
      Dim BasicDWString As String,BasicDW (   )   As String
      Dim MoneyDWString As String,MoneyDW (   )   As String
      Dim MoneyStr As String,ReturnStr As String,TempStr As String
      BasicDWString   =   "分,角,圆,拾,佰,仟,万,亿,万亿,兆,亿"
      MoneyDWString   =   "零,壹,贰,叁,肆,伍,陆,柒,捌,玖"
      BasicDW   =   Split ( BasicDWString,"," )  
      MoneyDW   =   Split ( MoneyDWString," )  
      MoneyStr   =   Format ( NMoney,"0.00" )  
      MoneyStr   =   Replace ( MoneyStr,".","" )  
      StrLen   =   Len ( MoneyStr )  
      ReturnStr   =   ""
      For X   =   0 To StrLen - 1
            TempStr   =   Mid ( MoneyStr,StrLen - X,1 )  
            ReturnStr   =   MoneyDW ( TempStr )   & BasicDW ( X )   & ReturnStr
      Next X
      ReturnStr   =   Replace ( ReturnStr,"零分","" )  
      ReturnStr   =   Replace ( ReturnStr,"零角","零拾","零" )  
      ReturnStr   =   Replace ( ReturnStr,"零佰","零仟","零万","零" )  
      Do
            ReturnStr   =   Replace ( ReturnStr,"零零","零" )  
      Loop While InStr ( ReturnStr,"零零" )   <> 0
      ReturnStr   =   Replace ( ReturnStr,"零圆","圆" )  
      If Right ( ReturnStr,1 )   <> "圆" Then
            ReturnStr   =   Replace ( ReturnStr,"圆","零" )  
            ReturnStr   =   ReturnStr & "圆"
      End If
      ReturnStr   =   ReturnStr & "整"
      NMoneyToSMoney   =   ReturnStr
End Function

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读