On Jun 15, 10:10 pm, JLatham <HelpFrom @ Jlathamsite.com.(removethis)
wrote:
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?

I actually need to have entries to be numbers or text but not times.
Thus I need the cells formatted as General. General formatting makes
10:00 show up as 0.416667. I need data entries to be restricted to non-
times. Can I have data validation set up to restrict time entries only
but still be able to enter numbers that can be used in formulas? Thanks