Just want to point out that suggested Custom Format will only handle non-floating point numbers and apparently will only correctly format a maximum of nine digits. Thank you so much for sharing this hack with all of our readers. Now in Excel the Default “,” and “$” Style will show the way you wanted. Do the same on the Currency Tab and Apply.Set digit groupings to the Indian grouping like this:.Goto the Control panel and select the “Region and Language” button.However there is better and more permanent solution using the Systems Regional Settings A permanent solution to Indian Number Formats: Indian Grouping 12,34,56,789.01 Quick and easy fix to show numbers in Indian format: Indian numbers are grouped differently than standard English numbers. Today we will learn how to format numbers and amounts in Indian currency format. This is a guest post by our excel ninja – Hui.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |