Want to use 100 seperator instead of 1000 seperator

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to represent ten crores as 10,00,00,000
instead of
100,000,000
in Microsoft Excel
Can anybody help?
 
Ilango,

Maybe you didn't notice that this is a Word forum, not an Excel forum!

FWIW, In Excel, you could use either:
.. a custom number format, as in 00\,00\,00\,000 or #\,00\,00\,000
.. a text formula, as in =TEXT(100000000,"00\,00\,00\,000") or
=TEXT(100000000,"#\,00\,00\,000")

Cheers
 
You must log in or register to reply here.

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

Indian Coma Style 2
Indian Comma style 10
SPELLNUMBER 1
Saving mail merged letters as seperate documents 2
Printing from Tables 1
Comma separator for numbers 2
Seperate ONE document into MULTIPLE 1
Seperate windows 2

Back
Top