Change Date from 20040102 to 2004/01/02

[anand_satavalekar]

I have date in a numeric format: 20040102 (which is in the yyyymmdd format).

How do I change it to Date format? I do not want to manually insert "/" between year and month and date.

 

[Norie]

You could use Data>Text to columns... and on the 3rd step choose YMD from the dropdown.

That should create a 'real' data value which you could then custom format as yyyy/mm/dd.

 

[phxsportz]

=LEFT(A1,4) & "/" & LEFT(RIGHT(A1,4),2) & "/" & RIGHT(A1,2)

Assuming your dates are in Column A

 

[just_jon]

Welcome to MrExcel -

You should be able to simple highlight the cell{s} in question, then click Format | Cells | select Date, then the desired format.

The above presupposes the cell is a true date.