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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date is backwards 20090123 7
Text to Date 8
General Number field has 19820431. How to convert to 04/31/1982? 5
Date(Year,Month,Day) not returnign correct date 8
Converting numeric value into short date 3
Number Format 5
removing dashes from SSN 1
splitting a cell in to three 4

Top