View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.newusers
Srinivasulu B Srinivasulu B is offline
external usenet poster
 
Posts: 3
Default Converting Numbers to words

Very nice group of people..who are willingto share...
seena
"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Very helpful, I'm certain and I've downloaded the file to examine, and
will
remember the location to offer future Indian currency help from.

"Shah Shailesh" wrote:


In case you need to convert as per indian number system (using Lakh,
Crore)you can download one addins "Indian Rupees" from below site.

http://in.geocities.com/shahshaileshs/

Or download one workbook "indianspellnoformula" (scroll to 5) from below
webpage, which has formula to convert numbers to words as per Indian
System.
No VBA codes required.

http://in.geocities.com/shahshaileshs/misc.htm


Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
If You Can't Excel with Talent, Triumph with Effort.

Free Addins Office Menu-2003 for Office-2007
http://in.geocities.com/shahshaileshs/menuaddins


"Srinivasulu B" wrote in message
...
I preapre inovices using Excel.
I have to put the total amount in words
I want to convert number to words.
Example
If cell A1 contains134.65 then in another cell (say B1) it should be
Rupees One Hundred Thirty Four and Paise Sixty Five only
(Please note the currency..Rupees, Paise and also "only" at the end)
Can nay one help?
seena