Change Mar 25 in to Date?
 

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!

Change Mar 25 in to Date?
 

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!

Change Mar 25 in to Date?
 

You should be able to select the cells, then: FormatCellsNumber
tabDateselect the format you want and OK.
"akphidelt" wrote:

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!

Change Mar 25 in to Date?
 

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!

Change Mar 25 in to Date?
 

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!

Change Mar 25 in to Date?
 

You're welcome!

BTW, Bob's suggestion of using Text to Columns also works.

--
Biff
Microsoft Excel MVP


"akphidelt" wrote in message
...
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!