formating a date
 

Hello,

When I pull data the dates came over looking like this:
1090325

This represents March 25, 2009. All of the dates have the 1 in front of
them. How do I eliminate the "1" and show a proper date?

Thanks

formating a date
 

With your value in A1, in another cell use:

=DATE(MID(A1,2,2)+2000,MID(A1,4,2),RIGHT(A1,2))

--
Gary''s Student - gsnu200842


"Jim" wrote:

Hello,

When I pull data the dates came over looking like this:
1090325

This represents March 25, 2009. All of the dates have the 1 in front of
them. How do I eliminate the "1" and show a proper date?

Thanks