I need to restrict a cells input to only being a value between 0 (zero) and 6000 but also allow a comma ( , ) a period ( . ) and an underscore ( _ ) symbol. How would I do that and include the allowed punctuation symbols and a minimum and maximum? Do I have to type every digit from 0 to 6000 in a separate line?
If it were just a number value range I’m aware of how to do that but including those 3 symbols too I do not know how to do and can’t figure it out if there’s an easier way to do it than typing 0 through 6000 in separate lines manually.
I can type 208wpm so I’ll be checking on this topic again in about a half hour.
I don’t know how to write macro scripts if that’s what I need and I only know how to write math and lookup formulas with spreadsheets. Anything else is outside of my spreadsheet knowledge.
Edit: I typed a 1 and drug the handle out to cut/paste to 6000 and found out the List text field only accepts 4096 lines. Surely there’s a symbol or something we can use to allow 0 through 25798237589275982057819507589215 if we wanted. Or isn’t there?
I’ve tried $ and :
Didn’t work.
.