Custom Data Validation Number Format

[Tamarissa]

Is there a way to set up a table column in the Custom Data Validation options to only allow numbers in the following formats?

• 000-00000-0
• 000-00000-00
• 000-00000-000

The first and second number sections will always be the same amount of digits, but the last section could have 1, 2 or 3 digits.

Thanks!

[Bo_Ry]

Please try

=SEARCH("???-?????-?*",A2)*(LEN(A2)<14)*(-SUBSTITUTE(A2,"-",)<0)

[Tamarissa]

Fantastic, that worked perfectly! Thank you so much!