I have a date 51231 (2005,dec,31) -I want to change to 2005/12/31
 

I have a bunch of date with dates entered as 51231 for (2005/dec/31), I want
to convert these numbers into date format 2005/12/31, any suggestions,
please...

thanks in advance,

cd

I have a date 51231 (2005,dec,31) -I want to change to 2005/12/31
 

=DATE(2000+LEFT(A1,1),MID(A1,2,2),RIGHT(A1,2))

Then...
<Format
<Cells
"Custom" tab
Enter: yyyy/mm/dd

--
Regards,
Dave


"Curtis" wrote:

I have a bunch of date with dates entered as 51231 for (2005/dec/31), I want
to convert these numbers into date format 2005/12/31, any suggestions,
please...

thanks in advance,

cd

I have a date 51231 (2005,dec,31) -I want to change to 2005/12
 

WOW,

I love this sight! You just made my dd, mm, yyyy! - thanks a ton.

cd

"David Billigmeier" wrote:

=DATE(2000+LEFT(A1,1),MID(A1,2,2),RIGHT(A1,2))

Then...
<Format
<Cells
"Custom" tab
Enter: yyyy/mm/dd

--
Regards,
Dave


"Curtis" wrote:

I have a bunch of date with dates entered as 51231 for (2005/dec/31), I want
to convert these numbers into date format 2005/12/31, any suggestions,
please...

thanks in advance,

cd

I have a date 51231 (2005,dec,31) -I want to change to 2005/12
 

How about

=DATEVALUE("200"&TEXT(A1,"0-00-00"))

and format as a date

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Curtis" wrote in message
...
WOW,

I love this sight! You just made my dd, mm, yyyy! - thanks a ton.

cd

"David Billigmeier" wrote:

=DATE(2000+LEFT(A1,1),MID(A1,2,2),RIGHT(A1,2))

Then...
<Format
<Cells
"Custom" tab
Enter: yyyy/mm/dd

--
Regards,
Dave


"Curtis" wrote:

I have a bunch of date with dates entered as 51231 for (2005/dec/31),
I want
to convert these numbers into date format 2005/12/31, any suggestions,
please...

thanks in advance,

cd