I have an excel 2013 file including the data:
User LastLogin A 03/15/2020 B user's machine not found C 03/09/2020 D 03/25/2020 E user's machine not found
The type of the
LastLogin column is “Text”.
I need to define a condition or develop a VB script to change the type of the cell based on its value. When it is a date, the format should be “Date”, otherwise should be “Text”.
I’ve checked examples online but only could find some that change the UI of the cell (highlighting etc.). How to change the type of the cell based on its value?
Any help would be appreciated.