ExcelBanter - how do i display 10,000,000.00 as 1,00,00,000.00

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

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

- - how do i display 10,000,000.00 as 1,00,00,000.00 (https://www.excelbanter.com/excel-discussion-misc-queries/39852-how-do-i-display-10-000-000-00-1-00-00-000-00-a.html)

debiprasad

how do i display 10,000,000.00 as 1,00,00,000.00

Bob Phillips

Custom format of

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

--
HTH

Bob Phillips

"debiprasad" wrote in message
...

All times are GMT +1. The time now is 05:07 PM.