Help validating numeric field

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?

Hi,

You may try if this works for you:
^(200000|[0-1]{0,1}[0-9]{0,5})$

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.

Hi,

You can try below if you don’t want to let users input zero.
^(200000|[1]{1}[0-9]{0,5}|[0-9]{1,4}[0-9]|[1-9])$