(excel addin) convert number into indian formats

CMA Ankur Pandey (Govt.Job) (4401 Points)

03 November 2011  

 

Download Excel Addin to convert numbers into Indian Rupees format i.e thousands,lac,Crore

for using this formula ,you have to first install  this addin in excel file

formula is

=Indian(A1)

For example 

cell A1 = 123456789

put in any cell where you want the number in words

=Indian(A1)

you will get

Rupees Twelve Crore Thirty Four Lac Fifty Six Thousand Seven Hundred Eighty Nine Only

 

Click Here to Download