excel convert number to words

[shrinivasmj]

hi

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


output in the below formate

[TABLE="width: 150"]
<tbody>[TR]
[TD="colspan: 2"][TABLE="width: 584"]
<tbody>[TR]
[TD="colspan: 2"]Instructions On How To Enter The ANNUAL INCOME (In Words)[/TD]
[/TR]
[TR]
[TD]$50,000[/TD]
[TD]Fifty Thousand Dollars Only[/TD]
[/TR]
[TR]
[TD]$50,250[/TD]
[TD]Fifty Thousand, Two Hundr ed And Fifty Dollars Only[/TD]
[/TR]
[TR]
[TD]$100,000[/TD]
[TD]One Hundred Thousand Dollars Only[/TD]
[/TR]
[TR]
[TD]$150,500[/TD]
[TD]One Hundred And Fifty Thousand And Five Hundred Dollars Only[/TD]
[/TR]
[TR]
[TD]$56,456,331[/TD]
[TD]Fifty Six Million, Four Hundred And Fifty Six Thousand, Three Hundr ed And Thirty One Dollars Only[/TD]
[/TR]
[TR]
[TD]$23,154,646[/TD]
[TD]Twenty Three Million, One Hundr ed And Fifty Four Thousand, Six Hundred And Forty Six Dollars Onl y[/TD]
[/TR]
[TR]
[TD]$548,546[/TD]
[TD]Five Hundred And Forty Eight Thousand, Five Hundred And Forty Six Dollars Only[/TD]
[/TR]
[TR]
[TD]$64,543[/TD]
[TD]Sixty Four Thousand, Five Hundred And Forty Three Dollars Only[/TD]
[/TR]
[TR]
[TD]$500,000[/TD]
[TD]Five Hundred Thousand Dollars Only[/TD]
[/TR]
[TR]
[TD]$500,250[/TD]
[TD]Five Hundred Thousand, Two Hundred And Fifty Dollars Only
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
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.