Never Mind, I just did it sheet by sheet.
"Ajtb" wrote in message
...
Hi Yonah

[A1] = Aug 23 2009
[A2] = next date

and so on

Select all dates in column 1 and then through the data menu, do Text To
Columns ... space delimited.

This will put the month in column 1, the day in column 2 and the year in
column 3.

Now in column 4, start with cell [D1], type in the following:

=TRIM(B1) & TRIM(A1) & TRIM(C1)

It will put 23Aug2009 in [D1].
Auto fill down.

Copy and paste values only to remove formulae once you have finished.

You now have dates that Excel will recognize.

HTH
Andrew Bourke



Yonah Sudwerts wrote:
I have cells that contain Dates such as "Aug 23 2009" but, they were copy
pasted in, and Excell does not see them as dates, is there anything I can
run that can convert them?

I want to be able in the end, that when I open Excell, it can jump to
Today;s date. And alternatively, to have some kind of search option, that
will lead me to any date I want.

But that is part 2, just looking to get the text recognized as Dates to
start.

Thanks in Advance,
Yoni