Number formating - in Lakh
You can format Number, which will appear in Lakhs apply in format cell. e.g. if you want to show figure in lakh 1,50,450 >>>> by applying it >>>> figure will be shown >>>> 1.50 right click >>>>format cell>>>> custom <<<<< use #\.00,