View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lakshmanagm Lakshmanagm is offline
external usenet poster
 
Posts: 1
Default for Email address format

in excel sheet one of the column is Email. i wnat to put
conditions/validations/functions to that email cell for it does not allowing
the wrong email format id's --like only text or only numericals or etc..(
wrong email format).
i.e if typed or copied the invalid email format id's i want to put alert
massage . Please tell me how it is possible.