Re: Excel and dates

["Bill" <brobins3d@xxxxxxxxx>]

Marie,

Here is one way to convert a numeric MMDDYY to an Excel Date Value:
=DATE(MID(TEXT(A1,"000000"),5,2),MID(TEXT(A1,"000000"),1,2),MID(TEXT(A1,"000
000"),3,2))

If you really want to convert it to a string value:
=TEXT(DATE(MID(TEXT(A1,"000000"),5,2),MID(TEXT(A1,"000000"),1,2),MID(TEXT(A1
,"000000"),3,2)),"YYYY/MM/DD")

Bill

> Anyone taking an AS/400 date and dll into excel.
> Does anyone know how to take the MMDDYY and convert it in excel to
> YYYY/MM/DD
>
> Marie Graziano



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---