data entry restricted to non-times
format the cell as Text or preceed your entries with a single apostrophe as
'14:22 to force the entries as text.
" wrote:
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?
|