Do you want to display numbers in excel sheet as arab, crore, lac, thousand, hundred in excel as shown :

Type the given formula in which you want to display and you are done.

=IF(AND(A1>999999999,A1<=99999999999),CONCATENATE(A1/1000000000,”Arab”),IF(A1>9999999,CONCATENATE(A1/10000000,” Crore”),IF(AND(A1>99999,A1<=9999999),CONCATENATE(A1/100000,” Lac”),IF(AND(A1>999,A1<=99999),CONCATENATE(A1/1000,” Thousand”),IF(AND(A1>99,A1<=999),CONCATENATE(A1/100,” Hundred”,),A1)))))