First, make a backup copy of your file

Format column as dd-mmm-yyyy, then select the column, do datatext to
columns, click next twice, under column data format select date and from
dropdown pick MDY, click finish. If necessary reformat as dd-mmm-yyyy again


--


Regards,


Peo Sjoblom





"Fredgus" wrote in message
...
That didn't do it, it just reduced the date to a set of 6 numbers,
29-Oct-06
turns into 102906. I should maybe add that Excel sees all of these dates
errors. Each cell has a little green triangle in the upper left corner,
mousing over the cell brings up a little notification icon with a drop
down
menu that gives several options for fix fixing or ignoring the error. I
can
change a block of cells all at once this way, but the dates are mixed, so
is
takes a while to select them all.

"Duke Carey" wrote:

Select a single, empty cell
Edit-Copy
Select all the dates
Edit-Paste Special-Add-Values

Should take care of it


"Fredgus" wrote:

I need to convert a list of dates that is formatted with 2 digit years,
89
for 1989 or 02 for 2002, to 4 digit years. The list has about 6,000
dates,
so I REALLY don't want to fix it one at a time. Excel seems to know
what to
do, it I simply double click the date and then move off it (by click or
enter
key) the date is adjusted to 4 years accroding the microsoft formula
(which
works for ALL the dates in the list). How do I have excel do all the
dates
at once?