Need help formatting cells

[tisahardknocklife]

Hey all,

I have some cells that look like this:

20070330 00:00

I need to get it into this format:

30/03/2007 00:00

But selecting format cells->custom-> doing dd/mm/yyyy hh:ss
isn't doing anything for me, and i've tried a few variations on that and no changes occur.

All help is appreciated with this!

[ratcat]

G'day,

Try the following formula may help. Don't forget to format the cell as dd/mm/yyyy hh:ss

Please Login or Register  to view this content.

[FDibbins]

Or this...
=DATE(LEFT(K17,4),MID(K17,5,2),MID(K17,7,2))+RIGHT(K17,5)
format as needed