How to convert number format to Date

G

galin

Hi,
I am trying to convert nubmer format to a date.
I have Employee_time in format:

20011206

and I 'd like to convert it to:

12/06/2001 or 2001/12/06

Thank you

Gali
 
P

Peo Sjoblom

Select the numbers, do data>text to columns, click next twice and under
column data format select date and the format
click finish
 
E

Earl Kiosterud

Galin,

I don't know why I'm answering this. There are 5 other people already doing
that, or have done it, but it hasn't slogged through the server farm yet.
And they'll all be the same. I hope.

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

The year must always be 4 characters, the month 2, etc., for this to work.
Format for the date format you want (Format - Cells - Number - Date or
Custom).
 
Top