Numbers to Text

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