Can anyone tell me how to convert numerals into words
for example 170 to onehundredandseventy like that
Can anyone tell me how to convert numerals into words
for example 170 to onehundredandseventy like that
Last edited by nadarajan; 10-01-2011 at 11:19 AM.
Hi nadarajan and welcome to the forum.
There are places that solve this problem in different ways. See
http://support.microsoft.com/kb/213360
http://www.meadinkent.co.uk/xlnumberstext.htm
http://www.yogeshguptaonline.com/200...bers-into.html
You can even download the function from
http://www.accountinghead.com/index....cel-2003-2007/
Last edited by MarvinP; 09-15-2011 at 10:10 PM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
As your location is given as India, I suspect you might be looking to find a solution for Rupees, Lakhs, Crore and Paise.
Try this link
Convert Number to Words (Indian Format)
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Thank you very much I got the macro from the link
Its working very nice.
thanks a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks