Restricting fields for whole/decimal numbers only

  • Thread starter Thread starter Jefff Sheldon
  • Start date Start date
J

Jefff Sheldon

We are in the process of doing a budget worksheet and
want to prevent users from getting lazy and entering
their budget divided by 12 months in a field.

For example: Budget for supplies is $70,000 for next
fiscal year.

The accountant would enter 70000/12 in field one and copy
it over.

This causes rounding errors in our Financial ERP system.
How can I restrict the field to only enter whole or
decimal numbers with no formulas/functions?

Thanks

JTS
 
Go to Data>Validation. In the Allow: dropdown box, one of the options for
the allowable data is whole number. You can even set a custom error message
for when invalid data is entered.

HTH
Mike.
 
One way:

Choose Data/Validation and select Whole number from the Allow dropdown
(you'll have to enter a range, but that may be an advantage, too.
 
Hi

however, choosing whole number seems to allow formulas in the cell as long
as they resolve to a whole number - any way to restrict this?

Cheers
JulieD
 
Not without using an Event macro. In the OP's case, I'd suspect that a
formula that resolved to a whole number would be acceptable, since it
wouldn't lead to rounding errors in his Finanaical ERP system.
 
Back
Top