excel convert number to words

[shrinivasmj]

hi

i am looking to convert numbers to words need vb or macro


output in the below formate

Instructions On How To Enter The ANNUAL INCOME (In Words) $50,000 Fifty Thousand Dollars Only $50,250 Fifty Thousand, Two Hundr ed And Fifty Dollars Only $100,000 One Hundred Thousand Dollars Only $150,500 One Hundred And Fifty Thousand And Five Hundred Dollars Only $56,456,331 Fifty Six Million, Four Hundred And Fifty Six Thousand, Three Hundr ed And Thirty One Dollars Only $23,154,646 Twenty Three Million, One Hundr ed And Fifty Four Thousand, Six Hundred And Forty Six Dollars Onl y $548,546 Five Hundred And Forty Eight Thousand, Five Hundred And Forty Six Dollars Only $64,543 Sixty Four Thousand, Five Hundred And Forty Three Dollars Only $500,000 Five Hundred Thousand Dollars Only $500,250 Five Hundred Thousand, Two Hundred And Fifty Dollars Only <tbody> </tbody>

<tbody>
</tbody>

all words start with caps latter
always ends with Only
COMA AND AND TO BE USED IN RESPECTIVE ARES

 

[Gary McMaster]

Below is a link to a "Spell Number" function from Microsoft:

https://support.microsoft.com/en-us/kb/213360

 

[Gary McMaster]

Make the changes highlighted in red below to the Microsoft sample to make it fully comply with your request.

'Main Function
Function SpellNumber(ByVal MyNumber)

.
.
.
 
           Cents = " And " & Cents & " Cents"
    End Select
    SpellNumber = Dollars & Cents & " Only"
End Function

4th line from bottom : Change lower case a in the word " and" to uppercase A
2nd line from bottom: add the text ' & " Only" ' to the end of the line.