To separate thousands with commas in Excel, we have 3 very simple ways to do it. We can change the position of the comma to separate units in a series of numbers or set the default separation style in the Excel table. The following article will guide you on how to use commas to separate thousands in Excel. All the methods below apply to all versions of Excel from Excel 2007 to Excel 2019.
1. Thousands separator in Excel using decimal button
This first method is suitable for quickly changing a specific cell. In that case, you just need to click on the decimal button icon to use it.
Click on the data that needs a decimal point or highlight the data area that needs to be changed, then click on the decimal button icon as shown below. Each time you click on this decimal icon, the number will automatically change accordingly.
2. Thousands separator in Excel via Excel Options
To fix the thousands separator in Excel in each data table without having to manually adjust the style, we will set it up from the settings in Excel.
Step 1:
In Excel, click on File and then click on Options below.
Step 2:
Switch to the settings interface on Excel, click on Advanced on the left side of the interface. Then go to the right to find the Editing Options group . Find the Automatically Insert a Decimal Point option and select it to use.
You will enter the decimal point position shown in the number series in the Places box below.
After setting up, click OK below to save this new setting. So when you work on Excel in any spreadsheet, decimals are automatically separated by commas at the position we have set.
3. Separate thousands in Excel using Format Cells
Step 1:
First , highlight the data columns that need to be formatted to display commas separating thousands or hundreds depending on the number series in the data table. Then right-click on the table and select Format Cells… from the drop-down list.
Step 2:
After the Format Cells dialog box appears, we click on the Number tab and then select the Number item . In the Decimal places section , we set it to 3. Check the Use 1000 Separator (,) item and then click OK .
The user will get the data table as shown below. The data will be separated by each unit row.
An extremely simple trick to display commas separating rows in a series of numbers on Excel. This will make the data table on Excel clearer, helping to read data more accurately and quickly.
Good luck!
Struggling with Microsoft Teams "Disabled Error" or Account Blocked? Discover step-by-step fixes, common causes, and prevention tips to get back online instantly. No tech skills needed!
Struggling with Microsoft Teams "Network Error" on Wi-Fi? Discover step-by-step fixes for solving Microsoft Teams Network Error on Wi-Fi, from cache clearing to DNS tweaks. Get back to seamless calls now!
Struggling with Microsoft Teams "Joining Error" via link? Discover quick, step-by-step troubleshooting fixes for smooth meeting joins. Updated with the latest solutions for desktop, web, and mobile.
Frustrated by Microsoft Teams "MS Team Error" 2026? Discover proven, step-by-step solutions to get back online instantly. Latest 2026 updates included for seamless fixes.
Struggling with Microsoft Teams "Loading Error" infinite loop? Follow our expert, step-by-step guide to fix it quickly. Clear cache, update app, and more for seamless teamwork. Works on Windows, Mac & web.
Struggling with Microsoft Teams "Chat Error" not sending messages? Discover step-by-step fixes for the latest Teams issues, from cache clearing to network tweaks. Get back to chatting seamlessly in minutes!
Tired of Microsoft Teams "Meet" joining error blocking your meetings? Discover proven, step-by-step fixes to resolve Microsoft Teams Meet joining issues quickly and get back to seamless collaboration. Updated with the latest troubleshooting tips.
Struggling with Microsoft Teams "Installation Has Failed" on Windows 11? Follow our step-by-step troubleshooting guide with proven fixes, from clearing cache to advanced repairs, to resolve the error quickly and painlessly. Get Teams running smoothly today!
Tired of Microsoft Teams Breakout Rooms not showing up? Follow our ultimate guide with step-by-step fixes, troubleshooting tips, and prevention strategies to get breakout rooms working seamlessly for productive meetings.
Tired of Microsoft Teams shortcut error blocking your workflow? Learn proven steps to solve Microsoft Teams shortcut error and startup crashes for smooth collaboration. Quick, easy fixes inside!
Struggling with Microsoft Teams "Planner Error" in channels? Discover proven, step-by-step solutions to resolve it quickly and restore seamless collaboration. No tech skills needed!
Discover how to set up Microsoft Teams for school and education effortlessly. Get free access, create classes, assignments, and meetings with our ultimate guide for teachers and students. Boost learning today!
Discover how to use Microsoft Teams Whiteboard in 2026 with this complete guide. Learn access methods, AI-powered features, step-by-step tutorials, and pro tips for seamless collaboration in virtual meetings. Boost productivity today!
Stuck with Microsoft Teams errors? Get step-by-step fixes for crashes, sign-in failures, audio glitches, and more. Proven solutions to resolve general Teams issues fast and frustration-free.
Stuck with Microsoft Teams Wiki not loading error? This ultimate troubleshooting guide delivers quick, step-by-step solutions to fix the issue fast and restore seamless collaboration.
