# 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
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
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.