20120626 to 26 Jun 2012

[slxia1]

how do i convert between date forms?
20120626 to 26 Jun 2012

[Richard Buttrey]

Hi,

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

and format it as dd mmm yyyy

[bolekblues]

Hi

I think it depends on how the value was initially written in an excel cell. If that was 'as a text', then the above will work. You can also try a little modification (with '-'):

=LEFT(A1,4)&"-"&MID(A1,5,2)&"-"&RIGHT(A1,2))

[slxia1]

im very interseted to see what you mean.
can you post a spread sheet with two different examples in a1 and a2?

[Richard Buttrey]

See attached

[slxia1]

haha i was tlaking to the other guy.