How do you change a number into words in Microsoft Excel?

Question

I'm trying to do something (without a lookup table) that will change a number like 25 into words ("twenty-five").  Is there a formula that will let me do that, or do I just need to create a big lookup table?

Cozmosis · Accepted Answer

Microsoft has made a custom function called SpellNumber. You can get it here...

http://support.microsoft.com/kb/213360

It's designed to spell out dollar amounts. e.g. 121.15 would spell out One hundred and twenty one dollars and fifteen cents. You could easily modify the code to elliminate the money terms. 

Replace the lines of code that look like the following with the following...

Select Case Dollars
Case ""
'Dollars = "No Dollars"
Case "One"
'Dollars = "One Dollar"
Case Else
Dollars = Dollars
End Select
Select Case Cents
Case ""
'Cents = " and No Cents"
'Case "One"
'Cents = " and One Cent"
Case Else
Cents = " point " & Cents
End Select

Anonymous · Answer

1

How do you change a number into words in Microsoft Excel?

2 Answers