Here is the formatted text:
Here are the steps to find records with values more than 2 decimal places in Microsoft Excel:
- Select the column of data that you want to check for decimal places.
- Click on the "Home" tab in the ribbon.
- Click on the "Number Format" drop-down menu in the "Number" group.
- Select "More Number Formats" at the bottom of the menu.
- In the "Format Cells" dialog box, select the "Number" tab.
- In the "Category" list, select "Custom."
- In the "Type" field, enter the following format:
- Click "OK" to close the dialog box.
Now, any cell in the selected column that has more than 2 decimal places will display the extra decimal places. You can then filter or sort the data to find the records that meet your criteria.