(Solved) – How to change type of a cell based on its value in Excel?

(solved)-–-how-to-change-type-of-a-cell-based-on-its-value-in-excel?

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.

Leave a Reply

Your email address will not be published. Required fields are marked *