Display the number in the Indian format

  • Thread starter Thread starter bala
  • Start date Start date
B

bala

How to display a number with comma in Indian format for eg: 12,34,567.00
 
Thank you very much .... It worked finally after I tried a lot of other
methods.
 
Hi,

I didn't check the link, but the quick way is to choose
Tools, Options, International tab, uncheck Use system separators and replace
Decimal separator with a comma and Thousands separator with a period.
 
Hi Shane,

The problem is grouping 2 and three digits, not the separators
 
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

Formatting Numbers 1
in excel how to display 2 digits ten thousand in indian format 2
How to format a cell to represent Indian Currency System? 2
comma in indian style 1
Applying Indian comma style 1
Indian Currency add 1
About comma style in MS Excel 1
How to format a number in Indian style in Excel? 2

Back
Top