I tried that to no avail. However, "Paste Special" worked. I should have
thought about that. Thanks to all.

"Gord Dibben" wrote:

Just because it is formatted as a date does not mean Excel recognizes it as
a date.

Try Bob's Text to Columns. Should convert to real dates.


Gord Dibben MS Excel MVP

On Tue, 16 Sep 2008 12:09:02 -0700, Michael
wrote:

Bob,

When I select a cell in the imported column and choose Properties, it is
formatted as a date. The same holds true for the the cell in which I
manually inserted a date. You would think that a plain CSV wouldn't confuse
Excel, especially when I can "tell" it that the column is a series of dates.

Mike

"Bob Umlas, Excel MVP" wrote:

What does the date look like? If it's something like 20080826, you can select
that column, use Data/text to columns, in step 3 change the column Format to
Date & select YMD, then click Finish

"Michael" wrote:

I exported a CSV file from one of my on-line accounts. The file has a list
of names, account numbers, and dates. Although the cells containing dates
are formatted as dates in the Format Cells-Number-Date, the sorting function
does not recognize that and will not sort oldest to newest. If I manually
retype a few of the dates into another column, Excel recognizes those as
being dates with no trouble. Is there something about importing from a CSV
that would cause this behavior?
Thank you.