Let's say the validation formula for C3 would be...
I am trying to utilize the validation feature in order to produce instruction and feedback to a user. The cell the validation is to be applied to, is formatted to be a decimal with one decimal place. However, if the user enters a value with more that one decimal place, it simply rounds up.
I would like to use the validation feature to produce feedback when more than one decimal place is used.
I would appreciate and suggestions/guidance with this issue.
Thank you in advance.
This one tip will help you sleep better tonight
A few seconds are all you need to get a better night's rest.