ExcelBanter - Decimels conversion

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Decimels conversion (https://www.excelbanter.com/excel-worksheet-functions/62792-decimels-conversion.html)

kingshuk_963

Decimels conversion

In Excel Worksheet a figure can be written in e.g. 100,000.00, how could I
change the figure in Indian type i.e., 10,00,000.00

Niek Otten

Decimels conversion

Format Custom as

[=10000000]##\,##\,##\,##0.00;[=100000]##\,##\,##0.00;##,##0.00

--
Kind regards,

Niek Otten

"kingshuk_963" wrote in message
...
In Excel Worksheet a figure can be written in e.g. 100,000.00, how could I
change the figure in Indian type i.e., 10,00,000.00

All times are GMT +1. The time now is 04:54 AM.