how to change date 20080115 to 15/01/2008?
 

how to change date 20080115 to 15/01/2008?
 

Try this, with your number in A1:

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

Hope this helps.

Pete

On Jun 25, 7:01*am, Soozler wrote:

how to change date 20080115 to 15/01/2008?
 

Data/ Text to Columns/ Delimited/ Next/ Next/ Date : YMD

And next time, please ask the question in the message body, not just in the
subject line.
--
David Biddulph

"Soozler" wrote in message
...