chadmiller
New Member
- Joined
- Jan 1, 2007
- Messages
- 23
Aloha Excel Guru’s.
I am hoping someone can provide a way to provide better validation than Excel’s default decimal validation (Excel 2007). I have cells configured to only accept decimal values between 0 and 100. I need to further restrict the input values to one decimal place.
Desired Result: Accept “70.1” as valid data but not “70.11”
Thanks in advance.
I am hoping someone can provide a way to provide better validation than Excel’s default decimal validation (Excel 2007). I have cells configured to only accept decimal values between 0 and 100. I need to further restrict the input values to one decimal place.
Desired Result: Accept “70.1” as valid data but not “70.11”
Thanks in advance.