only allow data entry to 2nd decimal

[jaymerozendaal]

When entering sales data in an exel spreadsheet, some extra numbers are
getting keyed in mistake.

the spreadsheet is formatted in accounting, 2 decimal places. the
correct figure is $24.13. However sometimes this is keyed in $24.133
by mistake, and the user doesn't know, because the number is still
formatted $24.13.

Is therre a way to get the user to enter data with no more than 2
decimal places?

 

[olasa]

Select all the cells that are affected then select from the menu:
Data>Validation>Select tab Settings. Allow:Custom, Formula:
=ROUND(A1,2)=ROUND(A1,3)

Note that A1 is the first cell in your selected range.

Hope it helped
Ola Sandström