Convert Date Format

[Mike]

I receive data with the date format as "20051106" [6 Nov 2005] which is OK
for me but end users want to see it in the more conventional "dd/mm/yyyy"
format. How can I transpose the data and insert separators.

Tks

Mike

[Naz]

You could use a formula such as

=RIGHT(E20,2)&"/"&MID(E20,5,2)&"/"&MID(E20,3,2)

assuming your data was in cell E20


HTH
--

_______________________
Naz,
London


"Mike" wrote:

> I receive data with the date format as "20051106" [6 Nov 2005] which is OK
> for me but end users want to see it in the more conventional "dd/mm/yyyy"
> format. How can I transpose the data and insert separators.
>
> Tks
>
> Mike

[Peo Sjoblom]

easiest way is to use data>text to columns, click next twice and under
column data format select date and YMD
and click finish

--
Regards,

Peo Sjoblom

(No private emails please)


"Mike" <[email protected]> wrote in message
news:[email protected]...
>I receive data with the date format as "20051106" [6 Nov 2005] which is OK
> for me but end users want to see it in the more conventional "dd/mm/yyyy"
> format. How can I transpose the data and insert separators.
>
> Tks
>
> Mike