Spell a number (not currency)

[PetrickM]

Good morning! I am using Excel 2003 and have a column within my spreadsheet that, through a formula, inserts a decimal that has formatting to show as a percent. I would like to know who to convert that number to words. I saw spellnumber (and love it!) but don't know how to edit it so that it converts properly.

Any help you be greatly appreciated!

Thank you!
Marcy

 

[Kenneth Hobson]

Remember what I said about the 100?
Use: =SpellNumber(A1*100)

 

[PetrickM]

I am so close - how do I edit the code to remove the word "point" from the result?

Thank you!
Marcy

 

[PetrickM]

Thank you so much! It works wonderfully!!!