hi!

any idea how to convert numbers into words like for example i input the number 1 and it will display the word "one". i want to make this in a large number like morethan or around 1 million.

Anybody can help me! Thankyou in advance

0

hi!

any idea how to convert numbers into words like for example i input the number 1 and it will display the word "one". i want to make this in a large number like morethan or around 1 million.

Anybody can help me! Thankyou in advance

0

use this code

''''''''''''''''''''''PASTE THIS INTO A MODULE''''''''''''''''''''''''''''''''

Public valnum, valsent As String

Private n, intpart, realpart, numchar, intword, realword, spltval, spltword As String

Private flag As Boolean

Public Sub WordConvert()

n = ""

intpart = ""

realpart = ""

numchar = ""

intword = ""

realword = ""

spltval = ""

spltword = ""

valsent = ""

If valnum = "." Then valnum = "0.00"

If valnum = "" Then Exit Sub

intpart = Format(Int(valnum), "000000000")

realpart = Right(valnum, 2)

spltval = realpart

Call ValFind

If spltword <> "" Then realword = spltword

spltval = Mid(intpart, 1, 2)

Call ValFind

If spltword <> "" Then intword = spltword + "Crore "

spltval = Mid(intpart, 3, 2)

Call ValFind

If spltword <> "" Then intword = intword + spltword + "Lakh "

spltval = Mid(intpart, 5, 2)

Call ValFind

If spltword <> "" Then intword = intword + spltword + "Thousand "

n = Mid(intpart, 7, 1)

Call ONES

If numchar <> "" Then intword = intword + numchar + "Hundred "

spltval = Mid(intpart, 8, 2)

If intword <> "" And Val(spltval) > 0 And realword = "" Then intword = intword + "AND "

Call ValFind

If spltword <> "" Then intword = intword + spltword

If intword <> "" And realword <> "" Then valsent = intword + " AND Paise " + realword + "Only"

If intword <> "" And realword = "" Then valsent = intword + "Only"

If intword = "" And realword <> "" Then valsent = "Paise: " + realword + "Only"

End Sub

Private Sub ValFind()

n = ""

spltword = ""

If Val(spltval) = 0 Then Exit Sub

n = Left(spltval, 1)

Call TENS

spltword = numchar

If flag = False Then n = Right(spltval, 1): Call ONES: spltword = spltword + numchar

End Sub

Private Sub ONES()

numchar = ""

If n = 0 Then numchar = ""

If n = 1 Then numchar = "One "

If n = 2 Then numchar = "Two "

If n = 3 Then numchar = "Three "

If n = 4 Then numchar = "Four "

If n = 5 Then numchar = "Five "

If n = 6 Then numchar = "Six "

If n = 7 Then numchar = "Seven "

If n = 8 Then numchar = "Eight "

If n = 9 Then numchar = "Nine "

End Sub

Private Sub TENS()

numchar = ""

If n = 1 Then n = Right(spltval, 1): Call TEENS: flag = True: Exit Sub Else flag = False

If n = 0 Then numchar = ""

If n = 2 Then numchar = "Twenty "

If n = 3 Then numchar = "Thirty "

If n = 4 Then numchar = "Fourty "

If n = 5 Then numchar = "Fifty "

If n = 6 Then numchar = "Sixty "

If n = 7 Then numchar = "Seventy "

If n = 8 Then numchar = "Eighty "

If n = 9 Then numchar = "Ninety "

End Sub

Private Sub TEENS()

numchar = ""

If n = 0 Then numchar = "Ten "

If n = 1 Then numchar = "Eleven "

If n = 2 Then numchar = "Twelve "

If n = 3 Then numchar = "Thirteen "

If n = 4 Then numchar = "Fourteen "

If n = 5 Then numchar = "Fifteen "

If n = 6 Then numchar = "Sixteen "

If n = 7 Then numchar = "Seventeen "

If n = 8 Then numchar = "Eighteen "

If n = 9 Then numchar = "Nineten "

End Sub

'''''''''''''''''''''''''''''FUNCTION USAGE''''''''''''''''''''''''''''''''

Dim c as double

c=1265

valnum = Format(c, ".00")

Call WordConvert

msgbox valsent

will return 'One Thousand Two Hundred AND Sixty Five Only'

0

can u cr8 me program that words converted to numbers.(1-50) using switch. pls help me.

0

Hi locsin,

Such questions were answered many times. I hope you can go through previous solved threads.

Thanks

0

Raising the dead brrrr! I thought necromancing was only in movies and games....

Soulcandra, please start your own thread and we will gladly help. Also show us what you have done as far as coding is concerned so we can help you from there.

This topic has been dead for over six months. Start a new discussion instead.

Recommended Topics

```
@model Stattips.Models.MatchesList
<br />
<div class="col-sm-8 container-fluid">
<table class="table table-striped ">
<tr rowspan="3"><ul class="breadcrumb">
<li><a href="#">Soccer</a></li>
<li><a href="#">Albania</a></li>
<li class="active">Kategoria Superiore</li>
</ul></tr>
<tr>
<th>Matches</th>
<th>Country</th>
<th>Odds</th>
</tr>
@using (Html.BeginForm("AddMatches", "Matches")) ...
```

i put this code::

```
matirial = raw_input ('what is your favorite lesson')
if matirial == 'maths' or 'math' or 'Maths' or 'Math' or 'رياضيات':
print 'like me broo!!'
elif matirial ...
```

I have access data table and vb . project .access data table include ID ,word and description Colum v b project include three text box and one list ...