Change of date format

[CassieL]

Hi everyone, I'm having a trouble of changing a table of date format.

I have a list of mix date format of dd/mm/yy and mm/dd/yy, is there any formula I could use to change the format to mm/dd/yy at once?

Thanks in advance!

-Cass

 

[63falcondude]

Are they actual dates or text values that appear to be dates? If the former, simply highlight the column and change the formatting to the desired format through the "Format Cells" window.

 

[CassieL]

They are actual dates, somehow the format cells couldn't do the work for dd/mm/yy. Please advise

 

[63falcondude]

When you use the formula =ISNUMBER(A2) down the entire dates column, assuming the dates column is column A starting on row 2, do you get any FALSE's?

 

[CassieL]

The one with dd/mm/yy are getting FALSE return, mm/dd/yy are getting TRUE return

 

[Dr. Demento]

Not sure if this helps, but just got a great answer for a similar problem:
https://www.mrexcel.com/forum/excel...myyyy-alphanumeric-yyyymmdd-numeric-only.html