Hi I just want to know if how can I convert the dates with a custom format in excel. In the data, it states "00.00.0" and fount out that it was in a custom format. Is there a way that I can convert it to its real date format?
@dunkindonut7777
We can use the DataTimeParse function as long as we know that the 00.00.0 stands for,
Maybe one sample input and output can help.