Help with date conversion - yyyymmdd to dd/mm/yyyy

[markperry]

Please can someone tell me how I can convert a date of format

20051212

to

12/12/2005?

Thanks in advance.

[Yngve]

Hi markperry

If it`s columns, select columns and change it
on the format, cells meny.

Regards
yngve

[Giles]

If it is stored as a text item then assuming data is in cell A1 - in a
suitable cell:

=right(a1,2)&"/"&mid(a1,5,2)&"/"&left(a1,4)

will put it into the order that you want.

"markperry" wrote:

>
> Please can someone tell me how I can convert a date of format
>
> 20051212
>
> to
>
> 12/12/2005?
>
> Thanks in advance.
>
>
> --
> markperry
> ------------------------------------------------------------------------
> markperry's Profile: http://www.excelforum.com/member.php...o&userid=27593
> View this thread: http://www.excelforum.com/showthread...hreadid=503334
>
>

[markperry]

This works perfectly - much appreciated.