Prev: Copy and paste an image
Next: File set up query.
From: sonykadanthodan on 6 May 2010 00:56
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.
From: Jacob Skaria on 6 May 2010 01:03
Hi Sony

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

http://www.dq.winsila.com/tips-tricks/an-excel-addin-to-show-currency-in-indian-format-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.
 | 
Pages: 1
Prev: Copy and paste an image
Next: File set up query.