Skip to main content

Changing Digit Grouping (Comma Style) in MS Excel - Million to Lakh

Changing Digit Separator System in Excel

Well this is a very common problem for our sub-continent i.e. Bangladesh, India, Pakistan, Nepal, Maldives, Sri Lanka. Cause our digit grouping system doesn't match with the international system. To be more specific - they use million, billion etc. But we use - lakh (also lac), crore etc. 

Users of the mentioned regions often face problem with the comma separator position in MS Excel. Cause the default system is international. It doesn't suit our digit grouping system. 

International System - Separates every three digits
  • 1,000.00
  • 10,000.00
  • 100,000.00
  • 1,000,000.00
  • 1,000,000,000.00

Subcontinental System - Separates every two digits after the 1st three digits
  • 1,000.00
  • 10,000.00
  • 1,00,000.00
  • 1,00,00,000.00
  • 1,00,00,00,000.00 

If you're familiar with the Indian Subcontinent system and if you're bound to use this system then it will be a big trouble if you don't know the solution. Well nothing to worry about as you are going through this article. Cause from the very next moment you're getting out of this trouble . . .

You know what's the most funny thing of this topic?? This problem might be related with MS Excel. But Excel itself is not responsible for this problem at all. Believe me! It's your Windows settings buddy. It's a very simple task. Just change the digit grouping system of Region from Control Panel. 

Changing the Digit Grouping from Control Panel
  • Press Start+R > Type Control > Hit Enter
  • Go to Region > Additional Settings
Region Settings in Control Panel
  •  From Numbers tab choose Digit grouping as shown below i.e. 12,34,56,789 
Customizing Number Fortmats in Windows
  • Again from Currency tab choose the same Digit grouping. 
Changing Digit Grouping From Control Panel
  •  Leave the dialogue boxes by pressing Apply > OK

That's it and you're all set! Don't forget the change the Digit grouping both from Numbers and Currency tab. 

From now on your Excel will display comma separators as bellow - 

 Thanks for being with Marks PC Solution. See you in the next topic . . .


Popular posts from this blog

GTA San Andreas Cheat Code (PDF)

After Vice City, San Andreas is the most popular game released by Grand Theft Auto (GTA). Usually GTA releases role playing game. San Andreas is such a game where you can act like a person. You can do everything. You have to take part in missions and complete them.  To make your missions easier, there are lots of cheat codes. If you can properly apply these codes, the tough parts of the game will be easier. Cheat codes are somewhat like keyboard shortcuts of computer programs.  I've shared 63 cheat codes below. There were more cheat codes in my collection, but I've omitted the less important cheats. Effects or result of the cheats are on the left side, and the codes are on the right side.  You can copy the following codes in your PC. And for your convenience, I've also uploaded a PDF file of these codes. You will find the download link at the bottom.  Effect Cheat Code Adrenaline Mode MUNASEF All Cars Explode ALLCARSGOB

Rules for Bengali Typing in PDF (Bijoy Layout)

Bijoy is the most popular layout for Bangla typing. The layout was developed by Mostafa Jabbar. He is the pioneer of Bangla typing in computer. More than 90% people use his Bijoy layout for Bangla typing. Today, I'm gonna share a PDF file with you that contains the Bijoy Keyboard layout with English fonts! If your keyboard doesn't have bengali fonts then you can print this PDF file to know where the bengali fonts are located in your keyboard. Additionally this file contains all the necessary rules and tips which are essential for Bangla Typing.  Now there are many other software available for Bangla Typing Layout. Such as Avro Easy, Unicode, Unibijoy etc. And there rules are also somewhat different from Bijoy. And some of their layouts follow the same rules like Bijoy. Hopefully this PDF file will support most of the rules when a layout is similar to Bijoy Layout.  Click to enlarge the image Download the PDF file from the button below. Follow

Download Puzzle Flash Game - Save Them

Hey Flash Game Lovers! Today you're getting an amazing puzzle game - Save Them! It's a flash game and the download size is only 382 KB. In this game, you have to move 3 missionaries and 3 cannibals from one side to another through a boat. In any side, if the number of cannibals is more than the number of missionaries, then cannibals will eat the missionaries!  Download Save Them Download the game from the above link. It's a zipped file. Download size is only 382 KB! After downloading the game, you have to unzip it first. Then double click on the SaveThem to start the game.  How to Play? After starting the game, you will get the instruction. You have to make sure that in no side, the number of cannibals is not more than the number of missionaries. This is your only challenge. You have to take them from left side to the right side of the lake through a boat.  Press on a character to jump to the boat. Thus you can take any two of them a