Convert Number Format or Currency Format
This is something I learned today. One of my friends called me for a help. He has Excel sheet with numbers like this.
33,32,100 and 31,10,100 – Typical Indian Currency format
If we select 2 or more cells with numbers in it, Excel displays the Count and Sum of those numbers.
But in the above case, it did not show up. You can quickly open up an Excel workbook & try this.
How to Convert Numbers to Indian Currency Format?
Problem with above case is that, Excel detects these numbers as just text or string. It will not show the sum even if you use the ‘=Value’ formula.
Here is what you can do in this case.
- Go to Windows Control Panel.
- Choose “Region & Language”
- Select ‘Additional Settings’
- In Digit Grouping – choose “12,34,567”
- Do this in the Currency Tab as well.
- Click Ok & Close.
Now, the numbers entered in the Excel (Example: 32,20,120) will be identified as numbers.
Note: In case if you would like to reverse this, there is option called “Reset” in the same Additional settings of Region & Language options.
Also Read: Excel VBA Loop Thru All Defined Names
Using Currency Format Option in Excel
The above explained option will affect all the Excel workbooks in the system. In case if you would like to change the format in a particular cell alone, then you can use the Format option of the cell.
- Right click on the cell.
- Choose Format cells.
- Choose Custom
- Enter: [>=10000000]##\,##\,##\,##0;[>=100000] ##\,##\,##0;##,##0
- Click ok.
This will change the format for the selected cell or range only. This way, you can have multiple Custom number formats in same Excel workbook.
Previous Post: Google Lens Project – That Understands Images Better than Before
Next Post: Facebook Messenger Streaks Feature
Excel Custom Number Format- Change Currency To Indian Format
- Games VCF Countif Record Macro Timer in Excel Task Manager print screen HTML Table Import Data Thumbnails Text to Speech TTS Candy Crush Block Apps in FaceBook C++ Programing Machine learning AI bulk email Excel VBA vba color index vba color codes Android social media Twitter Google+ Google Adsense Tips bitcoin Calendar in Excel outlook vba mass email Data Mining Excel Macro Facebook WhatsApp python Wordpress