ExcelBanter - comma in indian style

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

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

- - comma in indian style (https://www.excelbanter.com/excel-discussion-misc-queries/92333-comma-indian-style.html)

Sattu

comma in indian style

Plz explain how to put commas in Indian style (Not Million style).
Eg: 1,24,51,248.00

Bob Phillips

comma in indian style

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

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Sattu" wrote in message
...
Plz explain how to put commas in Indian style (Not Million style).
Eg: 1,24,51,248.00

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