Aug 13 2021 12:10 AM
Aug 13 2021 12:26 AM
Using data validation:
Select the cells you want to apply the rule to. In the following, I will assume that A1 is the active cell in the selection.
On the Data tab of the ribbon, click Data Validation.
Select Custom from the Allow dropdown.
Enter the formula
where A1 is the active cell.
Specify messages in the Input Message and Error Alert tabs, if you wish.
Alternatively, you could use the Worksheet_Change event procedure to round the input to 2 decimal places, but that would require users to allow macros.
Aug 13 2021 12:34 AM