Data Formatting

[Oh!Calcutta]

Dear All,

I need to write date in dd/mm/yyyy format only. But I receive data mainly in mm/dd/yy format and sometimes in mm/dd/yyyy format.

Pls help me.

Thanks in advance.

 

[VoG]

Select a column of dates, Data > Text to Columns, click Next twice, tick Date and select MDY then click Finish.