Three digit commas separator

  • Thread starter Thread starter jrhl
  • Start date Start date
J

jrhl

How can I setup Excel to show a comma every three digits like it used to be
in 2003? Right now it only shows the first comma after three digits.
 
What should 1234 look like

What should 12345 look like

And 123456

And 12345678

Thousands separator is set under Format>Cells>Number>Number

Enable would display 1,234 12,345 123,456 12,345,678


Gord Dibben MS Excel MVP
 
hi Gord,

can u tell me how to format a cell for figure 12345678 to be shown as
1,23,45,678.00 i. e. Indian style of numbering
 

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

Back
Top