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

P

Pete_UK

Try this, with your number in A1:

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

Hope this helps.

Pete
 
D

David Biddulph

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