cell format change in Excel

Hi Guys,

I will really appreciate your help.

Would someone know why once I change a cell format from date to general in one column it changes to a number, in another to a date in text format?

Any possibility to get the same format in the both columns?

Many Thanks