In Indian style, currency representation is different that default excel grouping e.g.
Amount: 12340000 is shown as 12,340,000 in excel.
However, in Indian style is written as: 1,23,40,000.
To get this representation in Excel, forma the current cell as:
[>=10000000]##\,##\,##\,##0;[>=100000] ##\,##\,##0;##,##0
Even this can be colored
[Red][>=10000000]##\,##\,##\,##0;[Blue][>=100000] ##\,##\,##0;[Green]##,##0
Amount: 12340000 is shown as 12,340,000 in excel.
However, in Indian style is written as: 1,23,40,000.
To get this representation in Excel, forma the current cell as:
[>=10000000]##\,##\,##\,##0;[>=100000] ##\,##\,##0;##,##0
Even this can be colored
[Red][>=10000000]##\,##\,##\,##0;[Blue][>=100000] ##\,##\,##0;[Green]##,##0
Comments
Post a Comment