Prev: Excel Trace Fomula dependence or precedence
Next: How can I get my mouse scroll wheel to work in excell?
From: Terry on 18 Mar 2010 15:08
How do I convert a data string date when it imports as yymmdd to full date
description.

example
100115 need to convert to Jan 15, 2010
91210 need to convert to Dec 10,2009
From: Bob Phillips on 18 Mar 2010 15:27
Try

=DATE(2000+LEFT(A1,LEN(A1)-4),MID(A1,LEN(A1)-3,2),RIGHT(A1,2))

--

HTH

Bob

"Terry" <Terry(a)discussions.microsoft.com> wrote in message
news:C6F9AC6E-996F-49CE-BFEC-425D5CBB7184(a)microsoft.com...
> How do I convert a data string date when it imports as yymmdd to full date
> description.
>
> example
> 100115 need to convert to Jan 15, 2010
> 91210 need to convert to Dec 10,2009


 | 
Pages: 1
Prev: Excel Trace Fomula dependence or precedence
Next: How can I get my mouse scroll wheel to work in excell?