Select the table with decimal points, right-click to set the cell format, select [Value] in the category, and set 2 in the number of decimal places on the right.
Click OK, and the last two decimal points in the table will be retained.
If you want to adjust freely, you can also increase or decrease the number of decimal places through the shortcut icon under the start menu.
The above is the detailed content of A simple way to retain two decimal places in Excel. For more information, please follow other related articles on the PHP Chinese website!