I have a numeric field on a sheet used for collecting mileage on vehicles. I need to create a validation rule that restricts the number entered by a user to a limit of 6 numeric characters and no more than 200,000. Any way to do this with regular expression?
You may try if this works for you:
Note: from your description, I assumed you’ll let users input numbers from 1 digit to 6 digits. If that’s not the case, please let me know.
That works, except I need it to where someone can’t put in a zero.
You can try below if you don’t want to let users input zero.