How to use comma separator in excel

Change the decimal point to a comma or vice versa

When you want to use the system separators again, select the Use system separators check box. Send No thanks. Type new separators in the Decimal separator and Thousands separator boxes. Click the Comma Style button with the comma icon in the Number group of the Home tab to quickly format selected cells with the thousands separator.

how to use comma separator in excel

Use the Comma Style format in a large table of financial data where you only want to display the currency symbols with the totals for the columns or rows. Monthly sales figures after formatting their cells with the Comma Style number format.

how to use comma separator in excel

You can always ask an expert in the Excel Tech Community , get support in the Answers community , or suggest a new feature or improvement on Excel User Voice. If you sometimes need to display numbers with different separators for thousands or decimals, you can temporarily replace the system separators with custom separators.

Like the Accounting format, the Comma format inserts commas in larger numbers to separate thousands, hundred thousands, millions, and. Expand your Office skills.

how to use comma separator in excel

Working with the Comma Style in Excel 2010. For a permanent solution, you must change the regional settings in Control Panel. The gap on the right between the last digit and the cell border accommodates the right parenthesis in negative values, ensuring that they, too, align precisely on the decimal point. Get new features first.

How can a comma separated list be converted into cells in a column for Lt?

Thank you for your feedback! On the Advanced tab, under Editing options , clear the Use system separators check box.

how to use comma separator in excel

The Comma Style format also known as the thousands separator in Excel 2010 often accompanies the Accounting number format. Contact Support. Any other feedback?

how to use comma separator in excel

All remaining detail data can be formatted with the Comma Style, and the decimal points will line up with the totals that use the Accounting format.

Was this information helpful?

Change the character used to separate thousands or decimals

By default, Microsoft Excel uses the system separators that are defined in the regional settings in Control Panel. It sounds like it might be helpful to connect you to one of our Office support agents. The Comma Style format also displays two decimal places and puts negative values in parentheses.

How can we improve it? Related Book Excel 2010 For Dummies.