David - The cells that I've now re-formatted using your suggested formula now
don't sort properly with the original ones. I think it's because the
'original' cells have 'PST' at the end, whereas the 'introduced/reformatted'
cells don't. Any ideas how I can get round that? I tried using 'concatenate'
to add a space then 'PST' to the new cells, once they had the correct format
for the date, but doing this messed up the date format again. I don't really
want to strip out the 'PST' bit from all the others, you never know when
you're going to need an element of data once you've deleted it... Thanks
for your help.

"David Biddulph" wrote:

If you put the year you want to use in B1, then use the formula
=DATE(B$1,MONTH(A1),YEAR(A1)-2000)+MOD(A1,1)
--
David Biddulph

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