Converting From Numeric Value to Word

How to Convert numeric value to English Word like 1 to one?

Questions by rajesh vadde

Showing Answers 1 - 3 of 3 Answers

Sivakumar

  • Feb 3rd, 2014
 

Code
  1. Dim a,b,c,d,res

  2. a=inputbox("Enter the value between 1 to 900")

  3. b=a mod 10

  4. c=right((a-b)*100/100,2)

  5. d=a*1000/1000-c-b

  6. b=cstr(b)

  7. If b=0 and c=0 Then

  8.         msgbox third(d)

  9.         elseif c=0 then

  10.         msgbox third(d) &" "&first(b)

  11.         else

  12.         msgbox third(d)&""&" " &sec(c) &first(b)

  13. End If

  14.  

  15. Function first(b)

  16.    Select Case (b)

  17. case 0:

  18. res=""

  19. case 1:

  20. res="one"

  21. case 2:

  22. res="Two"

  23. case 3:

  24. res="Three"

  25. case 4:

  26. res="Four"

  27. case 5:

  28. res="Five"

  29. case 6:

  30. res="Six"

  31. case 7:

  32. res="Seven"

  33. case 8:

  34. res="Eight"

  35. case 9:

  36. res="Nine"

  37. End Select

  38. first=res

  39. End Function

  40. Function sec(c)

  41. Select Case (c)

  42. case 10:

  43. res="ten"

  44. case 20:

  45. res="Twenty"

  46. case 30:

  47. res="Thirty"

  48. case 40:

  49. res="Fourty"

  50. case 50:

  51. res="Fifty"

  52. case 60:

  53. res="Sixty"

  54. case 70:

  55. res="Seventy"

  56. case 80:

  57. res="Eighty"

  58. case 90:

  59. res="Ninety"

  60. End Select

  61. sec=res

  62. End Function

  63. Function third(d)

  64. Select Case (d)

  65. case 100:

  66. res="Hundred"

  67. case 200:

  68. res="Two Hundred"

  69. case 300:

  70. res="Three Hundred"

  71. case 400:

  72. res="Four Hundred"

  73. case 500:

  74. res="Five Hundred"

  75. case 600:

  76. res="Six Hundred"

  77. case 700:

  78. res="Seven Hundred"

  79. case 800:

  80. res="Eight Hundred"

  81. case 900:

  82. res="Nine Hundred"

  83. End Select

  84. third=res

  85. End Function

  86.  


  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions