Excel2010: Numeric format settings

Time: 2022-04-28Source: Huajun Informationauthor:


In the picture below, we can see that the number of digits entered is irregular. What should we do if we want to set the number of digits? First select the cell that needs to be changed, and select "Set Cell" from the right-click menu. Format" is shown in Figure 1 below.

      
Figure 1

​​Select the "Number" option in "Set Cell Format", and you can modify the number of decimal places on the right. After the modification is completed, click the "OK" button, as shown in Figure 2 below.

      
Figure 2

After the setting is completed, you can see that all values ​​​​are rounded to two decimal places, as shown in Figure 3 below.

   
Figure 3

Where is the "Format - Conditional Formatting" in Excel 2010, and how to use conditional formatting to set cell values? This is a question that many friends will ask, so if you have learned it, you can tell him the answer.

Related articles更多>>

Popular recommendations