How to completely delete decimals in excel

Deletion method: First open the excel table that needs to be operated, select the cells that need to completely delete decimals; then select "Edit" - "Replace" at the top of the page, and enter ".*" in the "Find Content" input box. ”, do not enter any content in the “Replace with” input box; finally click “OK”.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

We enter a set of data and make a copy for reference.

Select the data to be adjusted.

Click edit and replace.

A dialog box pops up, enter .* when searching for content, which means to search for a point and the number after the point.

Replace with nothing, click Replace All.

The replacement is completed, and we can also see that the decimal in the selected area is gone.

# Compare before and after the adjustment. This method does not round, but directly deletes decimals.

Related learning recommendations: excel tutorial

The above is the detailed content of How to completely delete decimals in excel. For more information, please follow other related articles on the PHP Chinese website!