If you format the cell in an unambiguous date format (mmmm dd, yyyy), do your
dates still look like what you expect?

01/02/2006
could be January 02, 2006 or February 01, 2006.

If the dates are correct, just change the format to dd/mm/yyyy.

If the dates are not correct, I would re-import those values once more.

If they come from a text file, you can specify that your dates are already in
dmy order.

Gerald wrote:

would appreciate if I get help in my query

I have a excel file exported which has 500 rows in which date is in
mm/dd/yyyy format.

Need to have in dd/mm/yyyy format, tried text to columns, custom change date
format, nothing seems to work

plz help

thanks

--

Dave Peterson