Quick Date format question

[salmonchild]

If I am missing something very simple, please don't shoot me!

Need to change this:

2014-01-03 12:53:21 +0000

To be like this:

03/01/2014

For about 10,000 rows.

I have tried formatting the cells to no avail and have managed by using something like -=LEFT(A34,LEN(A34)-13) to remove the superfluous information, but I really would like it to look like it adheres to the UK 'standard' date format DD/MM/YYYY.

Many thanks

Salmon

 

[Abdul Matheen]

Hi,

Check this formula =TEXT(LEFT(A1,10),"DD/MM/YYYY").


Regards
Abdul Matheen

 

[salmonchild]

Fantastic, didn't think to use the TEXT function. Need to engage my brain.

Thank you very much Abdul!