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 - 

https://www.markspcsolution.com/2019/09/changing-digit-grouping-comma-style-in.html 

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

Comments

Post a Comment

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 ALL...
8 comments
Read more

Joining Texts from Multiple Cells in Excel

  Programs like MS Excel is full of functions. There are many useful functions that we don't use or we don't know about. One of them is CONCATENATE. It means joining or linking. With this function you can join texts from multiple cells. Let's see how . . . Suppose you're working in an Excel Worksheet where you need to combine texts from different cells. I'm gonna show you an example. Let's consider the image below -    What do you see ? I've imputed First Name and Last Name. In Full Name column I've used the formula i.e. CONCATENATE. And in the last column I've added Mr. with the full name.    So how do you use this formula ? Here it is -  =CONCATENATE(A2," ",B2) Observe it carefully. You can add more than 02 cells with this functions. Here I've just used 02 cells. You may think what is this " " for ? You may notice that there is a space between the two i.e. " & ".  If you don't use " " then you...
Post a Comment
Read more

Running Total/ Cumulative Sum in Excel

  Hey Guys! You should have noticed that I'm writing on MS Excel for last few days! To be honest I'm trying to learn some simple and useful tricks of Excel. And I'm also trying to share my knowledge with you. In this post I've come with such a little trick which maybe very useful if you face such situation. Let's begin . . .    Running Total/ Cumulative Sum It means the summation of numbers in a list and it will be updated each time when a number is added or changes. Look at the image below -    Look at the image. There are two columns with numbers. The first one is simply the number list. But the 2nd one is the summation of the list. Each time a new number is added to the first column the second one shows the summation. How to do this?  It's not a magic. Very simple sum formula is used to perform this task. But there is a little trick. You just need to lock the first cell and then every time it will update the running total list.  Here is my list. Sim...
Post a Comment
Read more