I've copied that formula into B1, is that correct? Maybe not, because it
doesn't return 11/26/2005, it returns 01/11/2005. It's corrected the year
but not the day of the month. How would I change it for other years?

"Gary''s Student" wrote:

If you format A1 as Text and paste in:

Nov 26 06:08:05

Then
=DATE(2000+RIGHT(A1,2),MONTH(1*A1),DAY(1*A1))
will display
11/26/2005
or any other date format you apply.
--
Gary's Student
gsnu200706


"browniebodrum" wrote:

I've got a spreadsheet in which, up to now, one column has the following
format for the date/time (in a single column): Nov-24-05 06:51:49 PST.
(It's a spreadsheet of EBay charges, previously copied and pasted from my
EBay 'Account Status' page). I've slipped up and failed to download the data
for ages, so for all of last year and part of 2005, I'll have to copy and
paste the data in from the invoices instead, but these have the following
format in that column: Nov 26 06:08:05. Of course, every time I paste this
data in, Excel treats it (in this particular example) as the 1st of November
2026. I'd be really grrateful for some suggestions on the quickest way to
change the format of the incoming data so that it's compatible with the data
in the existing spreadsheet...