ExcelBanter - comma seperater

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - comma seperater (https://www.excelbanter.com/excel-discussion-misc-queries/263234-comma-seperater.html)

sonykadanthodan

comma seperater

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

comma seperater

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.

All times are GMT +1. The time now is 09:53 PM.