Numbers to Text

Hi,

How do I convert a list of numbers to text

Example :

45 to Forty Five
69 to Sixty Nine

Can you help?

Thank you in advance

here is a vba code


Press Alt + F11 to start VBA editor
On the insert menu click on module
Copy and paste the below code in module sheet.

Please Login or Register  to view this content.

how to use
Enter a number in cell A1 like 5.90
then in cell A2 type =SpellNumber(A1)
It will give you the result.

Thank you very much Shijesh. You're a star my friend !

I blank out " " cents so that I dont get any currency right?

Also are you familiar with excel charts that I might want to control with drop down boxes etc?

Thank you again

Ok got it Shijesh. I didnt see the other functions. So I'll use the GetHundred function to get what I need.

Thanks again

Oops I have another problem now. I think the limit is till 999.

How do I convert 10579?
Or maximum in six digits 100500 ?

Thank you

See if link helps

http://www.excelforum.com/showpost.p...12&postcount=2

VBA Noob

Hi Sachin,

The function will convert number to text till Trillion....

If you dont want paise part then search for paise ..
You will find if else statement there ... try to manipulate that