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" wrote in message
...
How to format a cell to display numbers in lakhs with a cama separation
instead of millions