Apr 25 2007, 09:57 AM
I have a column that can contain either a date or text, is there a way to check if the cell contains a date vs text. Thanks Dan
Apr 25 2007, 10:59 AM
=ISTEXT(A4) will tell you if cell A4 is text and return either true or false, if you wish to turn text into a date, you can use =DATEVALUE(A4), and format the cell as a date.
Apr 25 2007, 11:06 AM
Works great, thank you very much. Dan
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here