把表格的货币数字变成英文
『壹』 如何把EXCEL里的合计数字金额变成英文的数字金额
自己去看微软官方的帮助文件吧：http://support.microsoft.com/kb/213360
一沾vba我就头晕 希望你能看的懂
这种功能 excel 基本功能并没有提供 只能借助vba程序来实现
希望对楼主有些帮助
『贰』 求在excel表中如何将数字转换成英文货币大写谢谢！
选中数字单元格，“格式”，“单元格”，“数字”选项卡，“分类”下选择“会计专用”或“货币”均可。可以选择各国货币符号。
『叁』 Excel中怎么将一个单元格中的金额数字转换成英文大写金额
英文金额没大写，只有中国有大写，你的意识是前面加美元或者英镑的符号？单元格式里面点货币，各种货币格式都有
『肆』 如何在excel中设置公式将数字转换为英文大写金额
使用数字转英文货币大写“自定义函数”，具体使用方法如下：
所需材料：Excel、数字转英文货币大写自定义函数（可通过网络复制粘贴）。
一、首先打开Excel表格文件，按Alt+F11打开VBA窗口，插入一个“模块”。
『伍』 WPS表格文件里面的阿拉伯数字怎么能自动转换成英文金额呢
有两种方法可以把阿拉伯数字转换成英文。
一、用公式比较复杂
="US DOLLARS "&UPPER(TRIM(IF(VALUE(RIGHT(INT(A1/1000000000),3))=0,"",LOOKUP(VALUE(LEFT(TEXT(RIGHT(INT(A1/1000000000),3),"000"),1)),{0,1,2,3,4,5,6,7,8,9;"","one","two","three","four","five","six","seven","eight","nine"})&IF(LEFT(TEXT(RIGHT(INT(A1/1000000000),3),"000"),1)="0"," "," hundred ")&IF(MID(TEXT(RIGHT(INT(A1/1000000000),3),"000"),2,1)="1",LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1/1000000000),3),"000"),2,2)),{10,11,12,13,14,15,16,17,18,19;"ten","eleven","twelve","thirteen","fourteen","fiifteen","sixteen","seventeen","eighteen","nineteen"}),LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1/1000000000),3),"000"),2,1)),{0,1,2,3,4,5,6,7,8,9;"","","twenty","thirty","fourty","fifty","sixty","seventy","eighty","ninety"}))&IF(MID(TEXT(RIGHT(INT(A1/1000000000),3),"000"),2,1)="1","",LOOKUP(VALUE(RIGHT(TEXT(RIGHT(INT(A1/1000000000),3),"000"),1)),{0,1,2,3,4,5,6,7,8,9;""," one"," two"," three"," four"," five"," six"," seven"," eight"," nine"}))&" billion ")&IF(VALUE(RIGHT(INT(A1/1000000),3))=0,"",LOOKUP(VALUE(LEFT(TEXT(RIGHT(INT(A1/1000000),3),"000"),1)),{0,1,2,3,4,5,6,7,8,9;"","one","two","three","four","five","six","seven","eight","nine"})&IF(LEFT(TEXT(RIGHT(INT(A1/1000000),3),"000"),1)="0"," "," hundred ")&IF(MID(TEXT(RIGHT(INT(A1/1000000),3),"000"),2,1)="1",LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1/1000000),3),"000"),2,2)),{10,11,12,13,14,15,16,17,18,19;"ten","eleven","twelve","thirteen","fourteen","fiifteen","sixteen","seventeen","eighteen","nineteen"}),LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1/1000000),3),"000"),2,1)),{0,1,2,3,4,5,6,7,8,9;"","","twenty","thirty","fourty","fifty","sixty","seventy","eighty","ninety"}))&IF(MID(TEXT(RIGHT(INT(A1/1000000),3),"000"),2,1)="1","",LOOKUP(VALUE(RIGHT(TEXT(RIGHT(INT(A1/1000000),3),"000"),1)),{0,1,2,3,4,5,6,7,8,9;""," one"," two"," three"," four"," five"," six"," seven"," eight"," nine"}))&" million ")&IF(VALUE(RIGHT(INT(A1/1000),3))=0,"",LOOKUP(VALUE(LEFT(TEXT(RIGHT(INT(A1/1000),3),"000"),1)),{0,1,2,3,4,5,6,7,8,9;"","one","two","three","four","five","six","seven","eight","nine"})&IF(LEFT(TEXT(RIGHT(INT(A1/1000),3),"000"),1)="0"," "," hundred ")&IF(MID(TEXT(RIGHT(INT(A1/1000),3),"000"),2,1)="1",LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1/1000),3),"000"),2,2)),{10,11,12,13,14,15,16,17,18,19;"ten","eleven","twelve","thirteen","fourteen","fiifteen","sixteen","seventeen","eighteen","nineteen"}),LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1/1000),3),"000"),2,1)),{0,1,2,3,4,5,6,7,8,9;"","","twenty","thirty","fourty","fifty","sixty","seventy","eighty","ninety"}))&IF(MID(TEXT(RIGHT(INT(A1/1000),3),"000"),2,1)="1","",LOOKUP(VALUE(RIGHT(TEXT(RIGHT(INT(A1/1000),3),"000"),1)),{0,1,2,3,4,5,6,7,8,9;""," one"," two"," three"," four"," five"," six"," seven"," eight"," nine"}))&" thousand ")&LOOKUP(VALUE(LEFT(TEXT(RIGHT(INT(A1),3),"000"),1)),{0,1,2,3,4,5,6,7,8,9;"","one","two","three","four","five","six","seven","eight","nine"})&IF(LEFT(TEXT(RIGHT(INT(A1),3),"000"),1)="0"," "," hundred ")&IF(MID(TEXT(RIGHT(INT(A1),3),"000"),2,1)="1",LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1),3),"000"),2,2)),{10,11,12,13,14,15,16,17,18,19;"ten","eleven","twelve","thirteen","fourteen","fiifteen","sixteen","seventeen","eighteen","nineteen"}),LOOKUP(VALUE(MID(TEXT(RIGHT(INT(A1),3),"000"),2,1)),{0,1,2,3,4,5,6,7,8,9;"","","twenty","thirty","fourty","fifty","sixty","seventy","eighty","ninety"}))&IF(MID(TEXT(RIGHT(INT(A1),3),"000"),2,1)="1","",LOOKUP(VALUE(RIGHT(TEXT(RIGHT(INT(A1),3),"000"),1)),{0,1,2,3,4,5,6,7,8,9;""," one"," two"," three"," four"," five"," six"," seven"," eight"," nine"}))&IF(VALUE(RIGHT(TEXT(A1,"0.00"),2))=0,""," AND CENTS "&IF(VALUE(RIGHT(TEXT(A1,"0.00"),2))<20,LOOKUP(VALUE(RIGHT(TEXT(A1,"0.00"),2)),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19;"","one","two","three","four","five","six","seven","eight","nine","ten","eleven","twelve","thirteen","fourteen","fiifteen","sixteen","seventeen","eighteen","nineteen"}),LOOKUP(VALUE(LEFT(RIGHT(TEXT(A1,"0.00"),2),1)),{2,3,4,5,6,7,8,9;"twenty","thirty","fourty","fifty","sixty","seventy","eighty","ninety"})&" "&LOOKUP(VALUE(RIGHT(TEXT(A1,"0.00"),1)),{0,1,2,3,4,5,6,7,8,9;"","one","two","three","four","five","six","seven","eight","nine"})))&" ONLY"))
『陆』 excel中如何将数字转换成英文货币
EXCEL中将人民币更换成美元操作方法如下：
一、选中所要更改在的单元格区域；
二、右击单元格区域，并在下拉菜单中点击“设置单元格格式”（或者使用快捷键Ctrl+1）；此时“设置单元格格式”对话框打开；
三、在“设置单元格格式”对话框里选择“数字”按钮；此时“数字”出现下拉框；
四、在“数字”出现下拉框里选择“货币”；
五、在“货币”的对话框里将人民币符号更改为美元符号，并点击保存即可。如下图所示：
『柒』 请问在excel表格中，怎样把钱数由数字变换成英文单词表示，比如说456，直接转换成four hundred fivty-six
这个有点麻烦哦。不过做一次，以后一劳永逸。
启动 Microsoft Excel。
按 Alt+F11 启动 Visual Basic 编辑器。
在“插入”菜单上，单击“模块”。
在模块表中键入下面的代码。
Option Explicit
'Main Function
Function SpellNumber(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 "
' String representation of amount.
MyNumber = Trim(Str(MyNumber))
' Position of decimal place 0 if none.
DecimalPlace = InStr(MyNumber, ".")
' Convert cents and set MyNumber to dollar amount.
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
Case ""
Dollars = "No Dollars"
Case "One"
Dollars = "One Dollar"
Case Else
Dollars = Dollars & " Dollars"
End Select
Select Case Cents
Case ""
Cents = " and No Cents"
Case "One"
Cents = " and One Cent"
Case Else
Cents = " and " & Cents & " Cents"
End Select
SpellNumber = Dollars & Cents
End Function
' Converts a number from 100-999 into text
Function GetHundreds(ByVal MyNumber)
Dim Result As String
If Val(MyNumber) = 0 Then Exit Function
MyNumber = Right("000" & MyNumber, 3)
' Convert the hundreds place.
If Mid(MyNumber, 1, 1) <> "0" Then
Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred "
End If
' Convert the tens and ones place.
If Mid(MyNumber, 2, 1) <> "0" Then
Result = Result & GetTens(Mid(MyNumber, 2))
Else
Result = Result & GetDigit(Mid(MyNumber, 3))
End If
GetHundreds = Result
End Function
' Converts a number from 10 to 99 into text.
Function GetTens(TensText)
Dim Result As String
Result = "" ' Null out the temporary function value.
If Val(Left(TensText, 1)) = 1 Then ' If value between 10-19...
Select Case Val(TensText)
Case 10: Result = "Ten"
Case 11: Result = "Eleven"
Case 12: Result = "Twelve"
Case 13: Result = "Thirteen"
Case 14: Result = "Fourteen"
Case 15: Result = "Fifteen"
Case 16: Result = "Sixteen"
Case 17: Result = "Seventeen"
Case 18: Result = "Eighteen"
Case 19: Result = "Nineteen"
Case Else
End Select
Else ' If value between 20-99...
Select Case Val(Left(TensText, 1))
Case 2: Result = "Twenty "
Case 3: Result = "Thirty "
Case 4: Result = "Forty "
Case 5: Result = "Fifty "
Case 6: Result = "Sixty "
Case 7: Result = "Seventy "
Case 8: Result = "Eighty "
Case 9: Result = "Ninety "
Case Else
End Select
Result = Result & GetDigit _
(Right(TensText, 1)) ' Retrieve ones place.
End If
GetTens = Result
End Function
' Converts a number from 1 to 9 into text.
Function GetDigit(Digit)
Select Case Val(Digit)
Case 1: GetDigit = "One"
Case 2: GetDigit = "Two"
Case 3: GetDigit = "Three"
Case 4: GetDigit = "Four"
Case 5: GetDigit = "Five"
Case 6: GetDigit = "Six"
Case 7: GetDigit = "Seven"
Case 8: GetDigit = "Eight"
Case 9: GetDigit = "Nine"
Case Else: GetDigit = ""
End Select
End Function
如何使用 SpellNumber 示例函数要使用该示例函数将某数字更改为书面文本，请使用下列示例中演示的方法之一：方法 1：直接输入通过将下面的公式输入单元格中，可以将 32.50 更改为“Thirty Two Dollars and Fifty Cents”：
=SpellNumber(32.50)
方法 2：单元格引用可以引用工作簿中的其他单元格。例如，在单元格 A1 中输入数字 32.50，然后在另一单元格中键入下面的公式：
=SpellNumber(A1)
方法 3：粘贴函数或插入函数可以使用“粘贴函数”（在 Excel 2000 和 Excel 2002 中）或“插入函数”（在 Excel 2003 中）来将自定义函数输入工作表中。Excel 2000 和 Excel 2002要使用“粘贴函数”，请按照下列步骤操作：
选择所需的单元格。
单击“常用”工具栏中的“粘贴函数”。
在“函数类别”下，单击“用户定义”。
在“函数名称”下，单击“SpellNumber”，然后单击“确定”。
输入所需的数字或单元格引用，然后单击“确定”。
单击“完成”。
Excel 2003要使用“插入函数”，请按照下列步骤操作：
选择所需的单元格。
单击“常用”工具栏中的“插入函数”。
在“或选择类别”下，单击“用户定义”。
在“选择函数”列表中，单击“SpellNumber”，然后单击“确定”。
输入所需的数字或单元格引用，然后单击“确定”。
『捌』 EXCEL里如何把数字金额转换成英文金额
选择要转的单元格，右键，设置单元格格式，数字，分类里的货币项，里面有你要的配置。
『玖』 excel里如何把数字转换成英文货币表达
看这里吧，微软的帮助
http://support.microsoft.com/kb/213360
不过结果跟你的要求少有不同
=SpellNumber(200)
显示
Two Hundred Dollars and No Cents
『拾』 EXCEL 中怎样把数字直接转换成英文
如何创建名为 SpellNumber 的示例函数- 启动 Microsoft Excel。
- 按 Alt+F11 启动 Visual Basic 编辑器。
- 在“插入”菜单上，单击“模块”。
- 在模块表中键入下面的代码。OptionExplicit
'MainFunction
FunctionSpellNumber(ByValMyNumber)
DimDollars,Cents,Temp
DimDecimalPlace,Count
ReDimPlace(9)AsString
Place(2)="Thousand"
Place(3)="Million"
Place(4)="Billion"
Place(5)="Trillion"
'Stringrepresentationofamount.
MyNumber=Trim(Str(MyNumber))
'Positionofdecimalplace0ifnone.
DecimalPlace=InStr(MyNumber,".")
'.
IfDecimalPlace>0Then
Cents=GetTens(Left(Mid(MyNumber,DecimalPlace+1)&_
"00",2))
MyNumber=Trim(Left(MyNumber,DecimalPlace-1))
EndIf
Count=1
DoWhileMyNumber<>""
Temp=GetHundreds(Right(MyNumber,3))
IfTemp<>""ThenDollars=Temp&Place(Count)&Dollars
IfLen(MyNumber)>3Then
MyNumber=Left(MyNumber,Len(MyNumber)-3)
Else
MyNumber=""
EndIf
Count=Count+1
Loop
SelectCaseDollars
Case""
Dollars="NoDollars"
Case"One"
Dollars="OneDollar"
CaseElse
Dollars=Dollars&"Dollars"
EndSelect
SelectCaseCents
Case""
Cents="andNoCents"
Case"One"
Cents="andOneCent"
CaseElse
Cents="and"&Cents&"Cents"
EndSelect
SpellNumber=Dollars&Cents
EndFunction
'Convertsanumberfrom100-999intotext
FunctionGetHundreds(ByValMyNumber)
DimResultAsString
IfVal(MyNumber)=0ThenExitFunction
MyNumber=Right("000"&MyNumber,3)
'Convertthehundredsplace.
IfMid(MyNumber,1,1)<>"0"Then
Result=GetDigit(Mid(MyNumber,1,1))&"Hundred"
EndIf
'Convertthetensandonesplace.
IfMid(MyNumber,2,1)<>"0"Then
Result=Result&GetTens(Mid(MyNumber,2))
Else
Result=Result&GetDigit(Mid(MyNumber,3))
EndIf
GetHundreds=Result
EndFunction
'.
FunctionGetTens(TensText)
DimResultAsString
Result=""'.
IfVal(Left(TensText,1))=1Then'Ifvaluebetween10-19...
SelectCaseVal(TensText)
Case10:Result="Ten"
Case11:Result="Eleven"
Case12:Result="Twelve"
Case13:Result="Thirteen"
Case14:Result="Fourteen"
Case15:Result="Fifteen"
Case16:Result="Sixteen"
Case17:Result="Seventeen"
Case18:Result="Eighteen"
Case19:Result="Nineteen"
CaseElse
EndSelect
Else'Ifvaluebetween20-99...
SelectCaseVal(Left(TensText,1))
Case2:Result="Twenty"
Case3:Result="Thirty"
Case4:Result="Forty"
Case5:Result="Fifty"
Case6:Result="Sixty"
Case7:Result="Seventy"
Case8:Result="Eighty"
Case9:Result="Ninety"
CaseElse
EndSelect
Result=Result&GetDigit_
(Right(TensText,1))'Retrieveonesplace.
EndIf
GetTens=Result
EndFunction
'.
FunctionGetDigit(Digit)
SelectCaseVal(Digit)
Case1:GetDigit="One"
Case2:GetDigit="Two"
Case3:GetDigit="Three"
Case4:GetDigit="Four"
Case5:GetDigit="Five"
Case6:GetDigit="Six"
Case7:GetDigit="Seven"
Case8:GetDigit="Eight"
Case9:GetDigit="Nine"
CaseElse:GetDigit=""
EndSelect
EndFunction
要使用该示例函数将某数字更改为书面文本，请使用下列示例中演示的方法之一：
方法 1：直接输入通过将下面的公式输入单元格中，可以将 32.50 更改为“Thirty Two Dollars and Fifty Cents”：
=SpellNumber(32.50)方法 2：单元格引用可以引用工作簿中的其他单元格。例如，在单元格 A1 中输入数字 32.50，然后在另一单元格中键入下面的公式：
=SpellNumber(A1)方法 3：插入函数要使用“插入函数”，请按照下列步骤操作：
Excel 2003：
- 选择所需的单元格。
- 单击“常用”工具栏中的“插入函数”。
- 在“或选择类别”下，单击“用户定义”。
- 在“选择函数”列表中，单击“SpellNumber”，然后单击“确定”。
- 输入所需的数字或单元格引用，然后单击“确定”。
Excel 2007 和 2010：
- 选择所需的单元格。
- 单击“公式”功能区上的“插入函数”。
- 在“或选择类别”下，单击“用户定义”。
- 在“选择函数”列表中，单击“SpellNumber”，然后单击“确定”。
- 输入所需的数字或单元格引用，然后单击“确定”。