use this for numbers upto 9 digits and 2 decimal places
goto
Insert -> Name -> Define
type "O" in names in workbook field
and copy & paste the below in "Refers to" field
={" "," one"," two"," three"," four"," five"," six"," seven","eight"," Nine"," ten"," eleven"," twelve"," thirteen"," fourteen","fifteen"," sixteen"," seventeen"," eighteen"," nineteen"}
click Add
type "T" in names in workbook field
and copy & paste the below in "Refers to" field
={" "," "," twenty"," thirty"," forty"," fifty"," sixty","seventy"," eighty"," ninety"}
click Add
assume the number is in A7
type the below formula in B7
=ROUND(INT(A7),)
type the below formula in C7
=ROUND((A7-INT(A7))*100,0)
type the below formula in D7
=PROPER(TRIM(IF(B7>=1,"Rupees ","")&IF(INT(B7/10^7)>19,INDEX(T,,INT(B7/10^8)+1)&INDEX(O,,MOD(INT(B7/10^7),10)+1),INDEX(O,,INT(B7/10^7)+1))&IF(INT(B7/10^7)>0," crore "," ")&IF(INT(MOD(B7,10^7)/10^5)>19,INDEX(T,,INT(MOD(B7,10^7)/10^6)+1)&INDEX(O,,MOD(INT(MOD(B7,10^7)/10^5),10)+1),INDEX(O,,INT(MOD(B7,10^7)/10^5)+1))&IF(INT(MOD(B7,10^7)/10^5)>0," lakh "," ")&IF(INT(MOD(B7,10^5)/10^3)>19,INDEX(T,,INT(MOD(B7,10^5)/10^4)+1)&INDEX(O,,MOD(INT(MOD(B7,10^5)/10^3),10)+1),INDEX(O,,INT(MOD(B7,10^5)/10^3)+1))&IF(INT(MOD(B7,10^5)/10^3)>0," thousand "," ")&IF(INT(MOD(B7,10^3)/100)>19,INDEX(T,,INT(MOD(B7,10^3)/10^3+1))&INDEX(O,,INT(MOD(B7,10^3)/100)+1),INDEX(O,,INT(MOD(B7,10^3)/100)+1))&IF(INT(MOD(B7,10^3)/100)>0," hundred "," ")&IF(MOD(B7,100)>19,INDEX(T,,INT(MOD(B7,100)/10)+1)&INDEX(O,,MOD(B7,10)+1),INDEX(O,,MOD(B7,100)+1))&IF(C7>0,IF(B7>=1," and ","")&" Paise "&IF(MOD(C7,100)>19,INDEX(T,,INT(MOD(C7,100)/10)+1)&INDEX(O,,MOD(C7,10)+1),INDEX(O,,MOD(C7,100)+1)),"")))
