dates in excel

[stabfpo]

i have imported data in a date format yymm (0806 = Jun 08). how can I make
excel recognize that?

 

[Gary''s Student]

Assuming four digits with the leading zero visible and data in column A, in
B1 enter:

=DATE(2000+LEFT(A1,2),--RIGHT(A1,2),1) and copy down

This formula will need adjustment if any dates are prior to 1/1/2000

 

[Dave Peterson]

Another one:
=--(TEXT(A1,"\2\000\-00")&"-01")
Format the cell as a date.

 

[ward376]

Dates and times in xl are just formatted numbers.

=VALUE(RIGHT(A2,2)&"/"&LEFT(A2,2))

format as date.

Cliff Edwards