How do I format cell for displaying value in lakhs ?

B

Babuli

How do I format a Cell to show number in thousands, lakhs, crores
instead of thousands, millions, billions?

E.g.
By default the number 12345678, would be displayed in Excel as follows
12,345,,678.00 I would like it to be displayed as
1,23,45,678.00.

Is it possible?

Please respond.
 
Top