– How to Change the Number of Decimals
– How to Turn Negative Numbers to Red
– How to Use Parentheses for Negative Numbers
A thousand separator is normally for the large numbers, making them easier to read. Please follow the steps below to apply a "thousands" separator.
Step 1: Select the cells with numbers;
Step 2: Click the "Home" Tab from Ribbon;
Step 3: Click "Comma Style" from the number section, you will see the thousands separator is added to the numbers.
The default comes with two decimals, please see How to Change the Number of Decimals to increase or decrease the number of decimals.
Alternatively, please use the following method to add "thousands" separators to the numbers.
Step 1: Select the cells with numbers;
Step 2: Right click to bring up the dialog box, from the list, click "Format Cells";
Step 3: In the "Format Cells" window, check "Use 1000 Separator(,)";
Step 4: Click "OK" at the bottom.
