Not able to cahnge Date format

Hi narendrabr

Select your data > Text to Columns on the home tab > Delimited > Next > Next > Select: Date > Finish

Format the cells as in your original post: yy/mm/dd