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,

Comments

Post a Comment

Popular posts from this blog

Use of - Format Painter

Image
  Format Painter (brush-icon )- in Home Format Painter in Excel is used to copy and apply the Same format as used in other. This is the easy method to make same formatting. How to use  Single use- if we want to format single time then  Step 1. Place curse on cell from where we want copy formatting Step 2. Click single time on format painter  Step 3. Put the curse to cell where we want same formatting style. Multiple use- if we want to use same format multiple cells or place then Step 1. Place curse on cell from where we want copy formatting Step 2. Click Twice time on format painter  Step 3. Put the curse to cell where we want same formatting style.     
Read more