Hi,

I have exported some data into a spreadsheet and the column I am having
difficulty with is the column that shows dates and times e.g. 1/31/2006
01:36:21PM.

Now what I need to do is:
1) take out the time and be left with the date (I have this formula)
=LEFT(A1,LEN(A1)-12)

2) change the date into UK format instead of US format (I have this
formula) =DATE(RIGHT(P8,2)+2000,LEFT(P8,2),MID(P8,4,2))

Both these work, but I needed them to both to work at the same time:

From: 1/31/2006 01:36:21PM.
To: 31/01/2006

Can anyone help. Thanking you in advance.

Kim
x