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

Comments

Post a Comment

Popular posts from this blog

Delhi Metro Multiple Payment Method

Image
 DMRC ( Delhi Metro Rail Corporation ) multiple payment modes with their pros and cons -: Token Purchase form   1) Ticket counter  2) Token Vending machine   Validity   1) Valid for the day of its purchase  Refund   1) Only unused tokens can be refunded  2) Within 60 minutes  3) From Token issue station  Only one way journey is permitted   Smart Card  Benefits 1) Save time 2)  Avoid standing in queue 3)  Freedom of choice of originating and destination station 4)  Minimum discount of 10% in every journey 5)  Used in DTC, Cluster & Metro feeder buses  Purchase from 1) Customer care center  2) Smart card vending machine  3) For Rs. 150/- (Rs. 50/-Security Deposit plus Rs. 100/- Add value)  Recharge At Customer Care Center 1) Minimum value Rs. 200/- 2)  Thereafter in multiple of Rs. 100/-  At Ticket Vending Machine 1) Minimum value Rs. 100/-  2) Thereafter in multiples of Rs. 50/-  Through Credit/Debit Card 1) Minimum value Rs. 100/- 2)  Thereafter in multiples of Rs. 50/-  3) Online
Read more