format a cell for displaying numbers in lakhs

How to format a cell to display numbers in lakhs with a cama separation
instead of millions

Here is a format that you can use


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


--
HTH

Bob Phillips

"naga" <[email protected]> wrote in message
news:[email protected]...
> How to format a cell to display numbers in lakhs with a cama separation
> instead of millions