Numbers to Text

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