ExcelBanter - custom format

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

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

- - custom format (https://www.excelbanter.com/excel-discussion-misc-queries/108400-custom-format.html)

TUNGANA KURMA RAJU

custom format

I want format a number comma separate in thousands,lacs,crores.I didn't fond
custom format for this eg. 100500700 to 10,05,00,700.
and also like to format the same 10.05 crores.

Toppers

custom format

Previous posting from Bob Phillips:

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

will format say 1234567890 as 123,45,67,890.00

HTH

"TUNGANA KURMA RAJU" wrote:

I want format a number comma separate in thousands,lacs,crores.I didn't fond
custom format for this eg. 100500700 to 10,05,00,700.
and also like to format the same 10.05 crores.

All times are GMT +1. The time now is 09:58 AM.