Hi Sony

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

http://www.dq.winsila.com/tips-trick...and-words.html

--
Jacob (MVP - Excel)


"sonykadanthodan" wrote:

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.