​Excel table setting tips: How to set the number of decimal places to retain

Excel tables are software that we often use in our daily office work. Recently, a friend asked the editor a question, that is, after entering decimals in the Excel table, how to set the number of decimal places for unified data? In fact, the setting method is very simple. Next, the editor will share the specific operation steps with my friends. Operation steps 1. Open the Excel table and select the data area that needs to be adjusted.

2. Press Ctrl+1, or right-click and click Format Cells in the sub-option.

3. After entering the window, click on the number column to select the value, then set the number of decimal places on the right and confirm.

4. You can see that it has been successfully set to the corresponding number of decimal places. For example, what we set here is 2 decimal places. Multiples of more than two decimal places are removed, and those with less than two decimal places are automatically filled in.

5. In addition, we can also click the icon as shown in the figure in the number column of the Start tab to increase or decrease the number of decimal places.

The above is the detailed content of ​Excel table setting tips: How to set the number of decimal places to retain. For more information, please follow other related articles on the PHP Chinese website!