PS....

I wrote:
Then select the new column of dates and press ctrl-C to copy. Then select
the original
column of dates, right-click and click Paste Special Value OK.

I neglected to add: and format the column of dates with the Custom "mmm
yyyy" format.


----- original message -----

"JoeU2004" wrote in message
...
"CEckels" wrote:
I'mnot sure if its a formatting error on his end, or if that is how he
actually entered the data.

Of course, you should determine that first. Select a cell, right-click
and click Format Number. If you see a Custom format of the form "myy",
select the entire column of dates, right-click and click Format Number,
then select Custom format and enter "mmm yyyy" without the quotes.

Otherwise....


Is there any way to convert the whole column so i dont' have to manually
change them?

One way.... In a parallel column, enter the following formula and copy
down as needed:

=datevalue(left(A1,len(A1)-2) & "/1/" & right(A1,2))

assuming the first bogus date (e.g. 586) is in A1. Then select the new
column of dates and press ctrl-C to copy. Then select the original column
of dates, right-click and click Paste Special Value OK. You can now
delete the new column of dates.

PS: One way to select a large range of cells is to enter the range in the
Name Box in the upper left corner above the worksheet.


----- original message -----

"CEckels" wrote in message
...
I have a huge spreadsheet where all the dates in the date column are
listed
as myy. For example "586" should be May 1986, and "801" should be August
2001.

Is there any way to convert the whole column so i dont' have to manually
change them?

If it helps, the file was an Access file my client burned toa CD. I
opened
it on another computer and this was how the column appeared, so I'mnot
sure
if its a formatting error on his end, or if that is how he actually
entered
the data.

Thanks