Change Mar 25 in to Date?

  • Thread starter Thread starter akphidelt
  • Start date Start date
A

akphidelt

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!
 
Do a Data>Text 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)
 
You should be able to select the cells, then: Format>Cells>Number
tab>Date>select the format you want and OK.
 
This works for me using U.S. English regional date settings:

=DATEVALUE(A1)

Then format as DATE.
 
Back
Top