Formula for conveting numerical value into wo

[Closed]
Report
-
 anay -
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

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

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.