数值转换英文

1—— one

2—— two

3—— three

4—— four

5 ——five

6 ——six

7——seven

8 ——eight

9——nine

10——ten

拓展资料：

11——eleven

12——twelve

13——thirteen

14——fourteen

15——fifteen

16——sixteen

17——seventeen

18——eighteen

19——nineteen

20——twenty

参考资料：百度翻译

five hundred twenty nine thousand and sixty three and eighty four cent标准翻译偶朋友是英语专业的好像还是外贸公司做的来HOHO~~给你参考吧

扩展资料

阿拉伯数字是现今国际上通用的数字。最初由古印度人发明，后由阿拉伯人传向欧洲，之后再经欧洲人将其现代化。由于阿拉伯人的传播，该数字最终被使用作为国际通用的数字，所以人们称其为“阿拉伯数字”。

阿拉伯数字大约在13到14世纪传入我国，由于我国古代的一种数字表达方式叫"算筹"，中国人写起来比较方便，所以阿拉伯数字当时没有在我国得到大规模的推广运用。20世纪初，随着我国对外国数学成就的吸收和引进，阿拉伯数字才开始慢慢使用。

阿拉伯数字由0，1，2，3，4，5，6，7，8，9共10个计数符号组成。采取位值法，高位在左，低位在右，书写顺序为从左往右书写。再借助一些数学符号（小数点、负号、百分号等），可以明确的表示所有的有理数，是一套相当完善的系统。

国内会计的书写《规范》第五十二条具体规定：“阿拉伯数字应当一个一个地写，不得连笔写。”特别在要连着写几个“0”时，一定要单个地写，不能将几个“0”连在一起一笔写完。数字的排列要整齐，数字之间的空隙应均匀，不宜过大。

529063.84：Five hundred and twenty-nine thousand and sixty-three point eight four.

由于英语数字的表达与汉语数字的表达方式不同，汉译时需要换算。例如：

1、ten thousand（10个千）一万

2、one hundred thousand（100个千）十万

3、ten million（10个百万）千万

4、one hundred million（100个百万）亿

5、one billion十亿（美式英语）

6、ten billion（10个十亿）百亿

7、one hundred billion（100个十亿）千亿

8、one trillion 万亿

词组成的常用短语

这类短语大多是由数词和介词搭配而成，或是数词和其他词类搭配而成，常用来表示不确定的范围和概念，有时也可表示事物所处的状态或其他情况。例如：

1、by hundreds 数以百计

2、by thousands 数以千计；大量

3、by(the) millions 数以百万计

4、by halves 不完全

5、hundreds of 数百；数以百计

6、thousands of 数千；数以千计

7、hundreds of thousands of 几十万；无数的

8、thousands upon thousands 万千上万

9、millions upon millions of 千百万

10、tens of， decades of 数十个

有两种方法可以把阿拉伯数字转换成英文。

一、用公式比较复杂

="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"))

二、你可以用VBA代码，ALT+F11——插入模块——粘贴如下代码：

Function SpellNumber(ByVal MyNumber)

Dim Dollars, Temp

Dim DecimalPlace, Count

ReDim Place(9) As String

Application.Volatile True

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

Case ""

Dollars = ""

Case "One"

Dollars = "One Dollar"

Case Else

Dollars = "US DOLLARS " & Dollars

End Select

SpellNumber = Dollars

End Function

Function GetHundreds(ByVal MyNumber)

Dim Result As String

If Val(MyNumber) = 0 Then Exit Function

MyNumber = Right("000" & MyNumber, 3)

If Mid(MyNumber, 1, 1) <> "0" Then

Result = GetDigit(Mid(MyNumber, 1, 1)) & " HUNDRED "

End If

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

Function GetTens(TensText)

Dim Result As String

Result = ""

If Val(Left(TensText, 1)) = 1 Then

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

Select Case Val(Left(TensText, 1))

Case 2: Result = "AND TWENTY "

Case 3: Result = "AND THIRTY "

Case 4: Result = "AND FORTY "

Case 5: Result = "AND FIFTY "

Case 6: Result = "AND SIXTY "

Case 7: Result = "AND SEVENTY "

Case 8: Result = "AND EIGHTY "

Case 9: Result = "AND NINETY "

Case Else

End Select

Result = Result & GetDigit _

(Right(TensText, 1))

End If

GetTens = Result

End Function

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(A1)即可得出结果：

one,two,three,four,fine,six,seven,eight,nine,ten,eleven,twelve,thirteen,fourteen,fifteen,sixteen,seventeen,eighteen,nineteen,twenty,twenty-one,twenty-two,twenty-three,twenty-four,twenty-fine