Dates backwards 20040927

I

infojmac

Hi,

I have a spreadsheet that has dates taken from a database and listed i
the following format

20040927

i want to change this to 27/09/2004

is this possible i tried the usual change to dd/mm/yyyy but obviousl
the date is backwards so it doesn't work.

Any ideas - cheers
 
A

Alex Delamain

=VALUE(RIGHT(a1,2)&"/"&MID(a1,5,2)&"/"&LEFT(a1,4))

will turn it back into an excel recognised date which you can the
format as require
 
A

Arvi Laanemets

Hi

Into free column enter the formula (in my example I assume that your date is
in cell A2):
=DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2))
 
Top