- Doubleclick on the TextBox or left click and choose Options
- Click DataValidation
- Click Add
- In the first dropdown select the TextBox (selected as default)
- In the second dropdown select "Does not match pattern"
- In the third dropdown select Userdefined pattern and enter the pattern.
Here is a growing list of patterns.
It's not perfect, because it allows a.b.@c.com and firstname.lastname@example.org., but it does allow email@example.com and firstname.lastname@example.org