I have a simple worksheet which includes a series of blood pressure readings. The date and time of each reading is recorded in column A and appear. All of the entries appears in the following format (configured using the Custom format):
MM/DD/YYYY HH:MM AM/PM
07/1/2017 10:01 AM
However, when I test the cells in column A using the ISTEXT function, I find that some of the cells return TRUE and others return FALSE. I suspect that might be the reason some of my average formulas are returning inconsistent averages.
What are my options for converting the existing dates to the proper format without losing the desired custom format?