How to change Currency format ?

[Clemens]

Hi friends,
I am in India and we have a Currency Format as 12,34,56,789.Whenever i try to put the amount values in Excel it take as 123,456,789. Can anyone tell me how to change the Currency Format From 123,456,789 to 12,34,56,789.I would be very thankful to him.

Thanks in Advance.

[Glenny]

Sure i will help you out with this issue you need to follow few steps:-

1. Click on Start.
   
   
2. Goto Settings - - > Control Panel - - > Regional and Language Options.
   
   
3. Select Customize in the Regional Option.
   
   
4. Goto Digital Grouping And select as 12,34,56,789.
   
   
5. Click on Apply and OK.
   
   
6. Restart your for Settings to get affected.