Formula for conveting numerical value into wo

Closed
sridhar - Jun 22, 2009 at 04:59 AM
 anay - Nov 27, 2009 at 03:30 AM
Hello,
formula for conveting numerical value into words in excel

2 replies

hello i want to know how to calculate a numeric value to english words
15
PLEASE TELL ME THE WAY TO CONVERT NUMERIC VALUES INTO WORDS IN MS ACCESS
0
PLEASE TELL ME THE WAY TO CONVERT NUMERIC VALUES INTO WORDS IN MS ACCESS
0
Private Function NumericToWords(ByVal myNum As String) As String
Dim units As String = ""
Dim numericToWordsOutPut As String = ""

Dim myNumArray(myNum.Length \ numGroup) As String
Dim index As Int16 = -1
For Count As Int16 = 0 To myNum.Length - numGroup Step numGroup
index += 1
myNumArray(index) = myNum.Substring(Count, numGroup)
Next

For Count As Int16 = 0 To (myNum.Length \ 3) - 1
units = thousendNum(((myNum.Length \ numGroup) - 1) - Count + 1)
numericToWordsOutPut &= CheckUnitOutput(myNumArray(Count)).TrimEnd(" ") & " " & units & " "
Next
myNumArray = Nothing
Return numericToWordsOutPut

End Function
0
Blocked Profile
Oct 31, 2009 at 05:27 AM
Dear Sir,

Please have the solution to your problem within this FAQ article at Kioskea site:

How To Convert a Numeric Value into English Word

Thanks.
2