>百科大全> 列表
excel如何将数字快速变成会计大写
时间:2025-04-13 06:59:42
答案

在 Excel 中,可以使用 VBA 宏来将数字快速转换为会计大写。以下是具体步骤

1. 打开 Excel,按下“Alt+F11”键,打开 VBA 编辑器。

2. 在 VBA 编辑器中,选择“插入”菜单下的“模块”选项,插入一个新的模块。

3. 在新的模块中,输入以下 VBA 代码:

```

Function ConvertCurrencyToEnglish(ByVal MyNumber)

Dim Dollars, Cents, Temp

Dim DecimalPlace, Count

ReDim Place(9) As String

Place(2) = " Thousand "

Place(3) = " Million "

Place(4) = " Billion "

Place(5) = " Trillion "

MyNumber = Trim(Str(MyNumber))

DecimalPlace = InStr(MyNumber, ".")

If DecimalPlace > 0 Then

Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & "00", 2))

MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))

End If

Count = 1

Do While MyNumber <> ""

Temp = GetHundreds(Right(MyNumber, 3))

If Temp <> "" Then Dollars = Temp & Place(Count) & Dollars

If Len(MyNumber) > 3 Then

MyNumber = Left(MyNumber, Len(MyNumber) - 3)

Else

MyNumber = ""

End If

Count = Count + 1

Loop

Select Case Dollars

推荐
Copyright © 2025 资讯知识网 |  琼ICP备2022020623号 |  网站地图