How do I format cell for displaying value in lakhs ?
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.
|