Hi,

I have a report that runs from a browser that pulls the date in American Format. MM/DD/YY

Is there a forumula that will convert it as.

Here is example :

Next Review Date
10/31/2016 12:00:00 AM
10/31/2016 12:00:00 AM
10/28/2016 12:00:00 AM
10/31/2016 12:00:00 AM
11/03/2016 00:00
10/31/2016 12:00:00 AM
10/31/2016 12:00:00 AM
11/02/2016 00:00
10/31/2016 12:00:00 AM
11/02/2016 00:00
11/07/2016 00:00
10/31/2016 12:00:00 AM
11/02/2016 00:00
11/03/2016 00:00
11/07/2016 00:00
11/01/2016 00:00

Im not fussed about the date although that will always be there.
I was hoping I could insert a column to the right of the dates and put a formula in so it switches the date from 10/31/2016 12:00:00 AM to 31/10/2016 12:00:00 AM.

Thanks in advance.

Nath'