[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
--
Gary''s Student - gsnu200790


"stabfpo" wrote:

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

[Dave Peterson]

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

stabfpo wrote:

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

--

Dave Peterson

[ward376]

Dates and times in xl are just formatted numbers.

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

format as date.

Cliff Edwards