how to write numerals in word form?

Answer 1

You just write out what you would say in words... for example:

23 = "twenty three"
165 = "one hundred sixty five"
3,143,851 = "three million one hundred forty three thousand, eight hundred fifty one"

Answer 2

Just how you say them
100 = one hunderd
1527 = one thousand five hunderd twenty seven

Answer 3

open the excel sheet press alt+f11 then module paste the given code Function English(ByVal N As Currency) As String Const Thousand = 1000@ Const Million = Thousand * Thousand Const Billion = Thousand * Million Const Trillion = Thousand * Billion If (N = 0@) Then English = "Zero": Exit Function Dim Buf As String: If (N < 0@) Then Buf = "negative " Else Buf = "" Dim Frac As Currency: Frac = Abs(N - Fix(N)) If (N < 0@ Or Frac <> 0@) Then N = Abs(Fix(N)) Dim AtLeastOne As Integer: AtLeastOne = N >= 1 If (N >= Trillion) Then Debug.Print N Buf = Buf & EnglishDigitGroup(Int(N / Trillion)) & " Trillion" N = N - Int(N / Trillion) * Trillion If (N >= 1@) Then Buf = Buf & " " End If If (N >= Billion) Then Debug.Print N Buf = Buf & EnglishDigitGroup(Int(N / Billion)) & " Billion" N = N - Int(N / Billion) * Billion If (N >= 1@) Then Buf = Buf & " " End If If (N >= Million) Then Debug.Print N Buf = Buf & EnglishDigitGroup(N \ Million) & " Million" N = N Mod Million If (N >= 1@) Then Buf = Buf & " " End If If (N >= Thousand) Then Debug.Print N Buf = Buf & EnglishDigitGroup(N \ Thousand) & " Thousand" N = N Mod Thousand If (N >= 1@) Then Buf = Buf & " " End If If (N >= 1@) Then Debug.Print N Buf = Buf & EnglishDigitGroup(N) End If If (Frac = 0@) Then Buf = Buf & " Only" ElseIf (Int(Frac * 100@) = Frac * 100@) Then If AtLeastOne Then Buf = Buf & " & " Buf = Buf & Format$(Frac * 100@, "00") & "/100" & " Only" 'added only at the end of this line Else If AtLeastOne Then Buf = Buf & " and " Buf = Buf & Format$(Frac * 10000@, "0000") & "/10000" End If English = Buf End Function Private Function EnglishDigitGroup(ByVal N As Integer) As String Const Hundred = " Hundred" Const One = "One" Const Two = "Two" Const Three = "Three" Const Four = "Four" Const Five = "Five" Const Six = "Six" Const Seven = "Seven" Const Eight = "Eight" Const Nine = "Nine" Dim Buf As String: Buf = "" Dim Flag As Integer: Flag = False Select Case (N \ 100) Case 0: Buf = "": Flag = False Case 1: Buf = One & Hundred: Flag = True Case 2: Buf = Two & Hundred: Flag = True Case 3: Buf = Three & Hundred: Flag = True Case 4: Buf = Four & Hundred: Flag = True Case 5: Buf = Five & Hundred: Flag = True Case 6: Buf = Six & Hundred: Flag = True Case 7: Buf = Seven & Hundred: Flag = True Case 8: Buf = Eight & Hundred: Flag = True Case 9: Buf = Nine & Hundred: Flag = True End Select If (Flag <> False) Then N = N Mod 100 If (N > 0) Then If (Flag <> False) Then Buf = Buf & " " Else EnglishDigitGroup = Buf Exit Function End If Select Case (N \ 10) Case 0, 1: Flag = False Case 2: Buf = Buf & "Twenty": Flag = True Case 3: Buf = Buf & "Thirty": Flag = True Case 4: Buf = Buf & "Forty": Flag = True Case 5: Buf = Buf & "Fifty": Flag = True Case 6: Buf = Buf & "Sixty": Flag = True Case 7: Buf = Buf & "Seventy": Flag = True Case 8: Buf = Buf & "Eighty": Flag = True Case 9: Buf = Buf & "Ninety": Flag = True End Select If (Flag <> False) Then N = N Mod 10 If (N > 0) Then If (Flag <> False) Then Buf = Buf & " " Else EnglishDigitGroup = Buf Exit Function End If Select Case (N) Case 0: Case 1: Buf = Buf & One Case 2: Buf = Buf & Two Case 3: Buf = Buf & Three Case 4: Buf = Buf & Four Case 5: Buf = Buf & Five Case 6: Buf = Buf & Six Case 7: Buf = Buf & Seven Case 8: Buf = Buf & Eight Case 9: Buf = Buf & Nine Case 10: Buf = Buf & "Ten" Case 11: Buf = Buf & "Eleven" Case 12: Buf = Buf & "Twelve" Case 13: Buf = Buf & "Thirteen" Case 14: Buf = Buf & "Fourteen" Case 15: Buf = Buf & "Fifteen" Case 16: Buf = Buf & "Sixteen" Case 17: Buf = Buf & "Seventeen" Case 18: Buf = Buf & "Eighteen" Case 19: Buf = Buf & "Nineteen" End Select EnglishDigitGroup = Buf End Function close the pge (not excel) type this word where u want get the word =english