Use this formula to convert a date stored as text into an actual date/time format:
=DATEVALUE(TEXT(E4,"MM/DD/YYYY"))+TIMEVALUE(TEXT(E4,"HH:MM")). – substitute the actual cell number for "E4"
Example: this shows a list of renewal dates, but the renewal_date column came in as Text. It was not possible to convert it to an actual date with the "format cell" function. The "renewal_date_converted" column was created by applying the formula above.
