Convert Date Format

M

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
 
N

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
 
P

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)
 
Top