DH Templates

In Excel , Is there a function to write the numbers as letter ?

I need to create an invoice template for me. So i'm looking for any function i can use it to write the total of the invoice by it self. Thanks "Nora M" for your effort. But what i need is this: if one cell has " 250 " then i need excel to write it with character like " Two hundred and fifty ".

Public Comments

1. when you want Excel to reconize the number as a letter, you need to write like this: ex: '23456 press enter 23456 with an apostrophe, when you press enter, the number should appear without it. remeber that this is a number, and it is considered as letters therefore you can't make any math functions with this number.
2. you might to write a 250 line macro
3. you have to use the =spellnumber() function. the bad news is...1st you have to create the function. the good news is...its just a copy and paste heres the vba script from Microsofts Knowledgebase. good luck edit- if you dont want dollars and cents, then the easiest thing to do is look for the quotes in the Dollars case loop and change "dollars" to "" and same with cents...just play around with it.