Wanderingpuppy
New Member
I’m needing a data validation formula for specific entries to a cell. I’m looking to have them not proceed til the entry fits the pattern exactly.
The pattern the entry into the cell must follow is ##-###|###.
Two digit number, hyphen, three digit number, bar, three digit number.
Any help is appreciated!!
The pattern the entry into the cell must follow is ##-###|###.
Two digit number, hyphen, three digit number, bar, three digit number.
Any help is appreciated!!
Last edited: