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