View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jbrass@cfu.net is offline
external usenet poster
 
Posts: 4
Default data entry restricted to non-times

I need to restrict data entry to non-times. All other data is ok. But
once a time is entered with a colon my scheduling template formats all
future data entered in that cell as a time. How do I do data
validation to exclude times?