Formula for conveting numerical value into wo

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

2 responses

hello i want to know how to calculate a numeric value to english words
PLEASE TELL ME THE WAY TO CONVERT NUMERIC VALUES INTO WORDS IN MS ACCESS
PLEASE TELL ME THE WAY TO CONVERT NUMERIC VALUES INTO WORDS IN MS ACCESS
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
Blocked Profile
31 Oct 2009 à 05:27
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.