Comma format for numbers in Excel

R

Raghav

In India, we use the metric system of units, but for numbers, we use the unit
"LAKH" for 100,000 and "CRORE " for 10,000,000 [ten million]. The comma
placement for 1 lakh is 1,00,000 and for 1 crore is 100,00,000. Literally
"lakhs" of Indians would like to use this format in their spreadsheets, but
I'm not able to find a way to get this format in Excel in Office XP [or
indeed in any older version of Office].

Does anyone know a way ?

Raghav Rao
Hyderabad
India
 

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

Excel does not accept text format! 0
custom number format not working 2
Custom Format for Numbers 4
Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
Using Comma in customise option 1
Comma separator for numbers 2
formatting rupees 8

Top