Changing Separator Comma In Excel

**NeedForExcel** · 03-08-2016, 06:37 AM

Hi,

For a number like 10000000 the default comma separator (Based On Windows Settings) will display as 10,000,000.00.

Is there a way to display the number like 1,00,00,000.00 without changing Windows settings?

**Pete_UK** · 03-08-2016, 11:53 AM

You can use a Custom Format, with this format string:

#\,##\,##\,##0.00

Hope this helps.

Pete

**NeedForExcel** · 03-09-2016, 12:35 AM

Hi Pete,

Thnx for the reply.. The Custom number format does work for me.. But for number like 10,00,000.00 it adds a comma at the start.. Like ,10,00,000.00. How can I get rid of it?

Changing Separator Comma In Excel

LinkBack

Thread Tools

Rate This Thread

Display

Changing Separator Comma In Excel

Re: Changing Separator Comma In Excel

Re: Changing Separator Comma In Excel

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Changing thousand separator in Excel

decimal separator is comma, not period

COMMA separator gone in Formulas

replace the comma separator to a dot and dot to a comma at the same time

[SOLVED] thousand separator conversion from dot to comma

Comma separator for custom Currency

thousands comma separator in VBA

Bookmarks

Bookmarks

Posting Permissions