comma seperater

[sonykadanthodan]

In excel worksheet comma seperator is based on 1000s . How can i change this
to 100 sperator eg: Nos One Lakh is displaying as 100,000.00 but one lakh
has to be displayed as 1,00,000.

 

[Jacob Skaria]

Hi Sony

Check out the below regarding an Add-In to show Currency in Indian format

http://www.dq.winsila.com/tips-tric...show-currency-in-indian-format-and-words.html