How to Apply US and Indian comma style in one excel sheet.

[Abhijeet Kharat]

Hi,

I want to apply US comma style as well Indian comma style for particular figures in One excel sheet.

Please refer below table for USD amount comma has been applied as per US style after every 3 Digits and for Amount in Rs. comma separator has been applied as per Indian comma Style.

(We don't want to used control panel option)

Sr.No.	Name	Amount in USD	Amount In Rs.
1	Sujit Verma	100,000.00	₹ 1,00,000.00
2	Anirban Roy	300,000.00	₹ 15,75,000.00
3	Anil Shetty	250,000.00	₹ 9,45,000.00
4	Vikas Sharma	6,000.00	₹ 3,78,000.00

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[LloydFinancials]

Abhijeet,

Try using this format on the Rs cells

[>=10000000]₹##\,##\,##\,###.#0;[>=100000] ₹##\,##\,###.#0;₹##,###.#0

Luke

 

[Rick Rothstein]

If any of the numbers in your "Indian" number column are greater than, or equal to, 1000000000, then Luke's suggested format will not work correctly for you. If you should have that situation, then the event code part of my mini-blog article here might be of some help...

<!-- title / author block --> [h=3]Excel Number Format: Indian Style Comma Separation[/h]