Excel Number Formatting in Crore ( Cr ) , Lakh ( L ) and thousand ( K )
IN EXCEL To format excel number in lakh(L) and thousand(K) only -: [<100000] 0.000,_)"K";#\.00,_)"L" To format excel number in lakh(L) and Crore(Cr) only -: [<10000000] #\.00,_)"L";#\.0000,_)"Cr" Video link --: https://youtu.be/sTtXI6r-f4A IN GOOGLE SHEET To write number according to Indian place value system [$₹][>9999999]##\,##\,##\,##0.00;[$₹][>99999]##\,##\,##0.00;[$₹]##,##0.00