![]() [ Control Panel > Regional Settings > Numbers, but that will affect all your Excel sheets and the change will be visible only on your system and not on your files which you send to others. Right-click on the cells which you want to display as lakhs, and click on Format Cells, then go to the Custom category and enter the below formats: Here's a trick to get them to display correctly: ![]() However, if you have Kutools for Excel’s Delete Blank Rows utility, that is a piece of cake. If you want to delete all blank rows across the whole workbook, how troublesome you are while deleting rows one sheet by one sheet. You may have faced the problem of Excel always displaying amounts in millions and not in lakhs e.g. Delete infinite blank rows in a selection/worksheet/workbook with Kutools for Excel. During Q4 2018, Apple and Samsung sold 64.5 million units and 70.8 million units respectively. Let us take the example of global mobile phone sales. ![]() Here's a useful Excel tip for users in India and other places that use number formats like 100,00,00,000 instead of 1,000,000,000: Market Share (75 million / 210 million) 100 Market Share 35.71 Therefore, the market share of company B was 35.71 during FY18.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |