Numbers to Words

Excel has no built-in function to spell out numbers, but one long formula can do it: 456,571 becomes Four Hundred and Fifty Six Thousand Five Hundred and Seventy One. Copy the formula below, or for rupees in lakh and crore, use the RUPEES function instead. fx=TRIM(CHOOSE(LEFT(TEXT(B3,”000000000″))+1,,”One”,”Two”,”Three”,”Four”,”Five”,”Six”,”Seven”,”Eight”,”Nine”)&IF(–LEFT(TEXT(B3,”000000000″))=0,,IF(AND(–MID(TEXT(B3,”000000000″),2,1)=0,–MID(TEXT(B3,”000000000″),3,1)=0),” Hundred”,” Hundred and “))&CHOOSE(MID(TEXT(B3,”000000000”),2,1)+1,,,”Twenty “,”Thirty “,”Forty “,”Fifty “,”Sixty “,”Seventy … Read more