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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding and Displaying as Text 1
Replace million-billion number format to lakhs-crores format 1
Conversion of actual fig. in Lakhs / Crores 0
Excel does not accept text format! 0
Custom Format for Numbers 4
format a cell for displaying numbers in lakhs 1
Custom Number Format 2
how o i use commas for lakhs 1

Top