Automatically convert Date format M/D/YYYY TO DD/MM/YY

Hi Forum,

I am downloading excel worksheet from our companies website in this file date coloumn comes as m/d/yyyy. I want formula to change it automatically to DD/MM/YY.

Thanx