Can't believe it was that easy... thanks Mr. Valko!

"T. Valko" wrote:

This works for me using U.S. English regional date settings:

=DATEVALUE(A1)

Then format as DATE.

--
Biff
Microsoft Excel MVP


"akphidelt" wrote in message
...
Howdy, for some reason I just can't get this to work. I have an imported
spreadsheet with about 30,000 rows of data... but the dates are put in as
Tue
Mar 25. So I parsed out all the dates to get for example Mar 25. Now I
can't
seem to figure out how to get that in to a date format.

So the sample data looks like this

Mar 25
Mar 28
Apr 3

I would like it to show up like this with a date format

3/25/2008
3/28/2008
4/3/2008

Any help will be appreciated... thanks!