I have a file with text as follows:
31-Jul-2007 05:07:48 PM PDT

Is there some way for excel to convert this to a standard date?

Assuming that the date is A1:

=DATEVALUE(LEFT(A1,11))

The LEFT function extracts the first 11 characters on the left side of the
entry and the DATEVALUE function converts the text to a valid date serial
number. You'll have to format the cell for the date format of your choice
--
Kevin Backmann


"Fellow Wanderer" wrote:

I have a file with text as follows:
31-Jul-2007 05:07:48 PM PDT

Is there some way for excel to convert this to a standard date?

Assume this is in one column and you only need the date?
If you want to keep the time make sure there is an empty column to the
right,
select the column, do datatext to columns, select fixed width and click
next, make sure one line is right after the year and double click the other
lines and click next, if you want to remove what's to the right of the date
select the column to the right and select don not import (skip) then click
finish
If you want to keep what's to the right just click finish in step 2 after
setting the lines


--


Regards,


Peo Sjoblom



"Fellow Wanderer" wrote in
message ...
I have a file with text as follows:
31-Jul-2007 05:07:48 PM PDT

Is there some way for excel to convert this to a standard date?

Thank you to both of you! Both were great suggestions and I really
appreciate it.

"Fellow Wanderer" wrote:

I have a file with text as follows:
31-Jul-2007 05:07:48 PM PDT

Is there some way for excel to convert this to a standard date?