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

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

easiest way is to use datatext 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" wrote in message
...
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