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" <naga@discussions.microsoft.com> wrote in message
news:C2E7B233-B556-460F-A223-6CDB6718CA61@microsoft.com...
> How to format a cell to display numbers in lakhs with a cama separation
> instead of millions