View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default Converting Numbers to words

Two sources of routines to convert numbers to words a

http://www.ozgrid.com/VBA/ValueToWords.htm
http://support.microsoft.com/default.aspx/kb/213360

You should be able to modify one of those to add Rupees, Paise and only. If
not, let us know which code you choose and we'll try to help.


"Srinivasulu B" wrote:

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