Converting Dates with custom format in excel

[dunkindonut7777]

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?

[Qiu]

@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.