How to apply comma style in Excel sheet

8 November 2024By Alice

The comma style is a useful feature that helps enhancing the readability of numerical data. This guide will walk you through the easy steps of applying and customizing the comma style in Excel sheets.

How to apply comma style in Excel sheet

What is the comma style?

The comma style, also known as the thousands separator, is a feature that formats numbers by adding commas to separate groups of thousands. It also creates a standardized appearance for financial or statistical data.

Here’s an example:

345678466.89 -> 345,678,466.89

Depending on your country or your language’s rules, commas might be replaced by dots.

For example, in Europe it’s common to find this format -> 1.234,50

While in the US the following one is widely used -> 1,234.50.

Using comma style can bring some benefits to your work – it can improve readability, since large numbers are easier to interpret when commas separate thousands, and ensure consistent presentation, showing your data uniformly. These factors are key in giving your document a professional appearance.

How to apply comma style

Now that we know what comma style is, let’s see how to apply it in sheets using ONLYOFFICE spreadsheet editor as an example.

First of all, you have to open the editor and check if the format in use is the one you need. To do so, open File tab and navigate to Advanced settings.

How to apply comma style in Excel sheet

Here, go to Regional settings and choose the desired format based on language and location.

You can also customize the separators according to your preference. To do so, uncheck Use separators based on regional settings and enter them yourself.

How to apply comma style in Excel sheet

Now, insert your numbers in the sheet.

How to apply comma style in Excel sheet

Simply select the numbers you wrote and click on the comma style symbol in Home tab.

How to apply comma style in Excel sheet

All the selected numbers will be displayed with commas separating group of thousands.

How to apply comma style in Excel sheet

It couldn’t be any easier than this!

Now that you know how to use this feature, you can start using in your sheets.

Need powerful editors for all your documents? ONLYOFFICE Docs is the suite you might be looking for. Have a look at this video to learn everything about the latest version.

Get ONLYOFFICE Docs

Create a free online ONLYOFFICE DocSpace account, or download the desktop app for Windows, macOS or Linux.

START ONLINE     GET DESKTOP APP

Create your free ONLYOFFICE account

View, edit and collaborate on docs, sheets, slides, forms, and PDF files online.