Enter Numeric Values only

[gheyman]

Is there a way to limit what a user can enter into a cell. I need for them to only enter number. Even with comments and data validation input messages I still get users entering text.

Some people enter things like "100.5 hrs." instead of "100.5"

 

[mabalo76]

go to "DATA" --> Data Validation

choose "Decimal", select minimum and maximum then press ok

 

[Alice Morland]

In addition to the Data Validation setting, I'd also include an Error Allert to let your users know what they did wrong and what should they enter instead. The Error Alert is in the same Data Validation pop-up, only in the 3rd tab.

Check out this short explanation

 

[mabalo76]

choose your own "Input Message" and "Error Alert" message if you want

 

[gheyman]

Thanks!