View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default convert number to intext

Perhaps start with
http://www.ozgrid.com/VBA/ValueToWords.htm
their code is set up to work with USDollars, but should be adapatable for
your purposes.

"ramesh k. goyal - abohar" wrote:

I am looking for a function to convert a amount (number) to text in indian
ruppees. For example, 23456789.00 would display as "Two crore thirty four
lacs fifty six thousand seven hundred eighty nine ruppees & 00 paisa".

Pleeeeeeze send any solutions.

Thanx in advance.

Ramesh goyal