Do a DataText To Columns, and hit Next twice, and select the date option in
Column data format.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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!