Don,

I'm sorry to say that I am not a programmer, so I didn't understand what you
are saying. Consequently, I have no way to implement your suggestion, as I
don't know where to begin. Thank you.

Mike

"Don Guillett" wrote:

Try this after selecting the range with your dates

Sub fixmynums()
Application.ScreenUpdating = False
'lr = Cells.SpecialCells(xlCellTypeLastCell).Row
On Error Resume Next
For Each C In Selection 'Range("a1:q" & lr)
If Trim(Len(C)) 0 And C.HasFormula = False Then
C.NumberFormat = "General"
C.Value = CDbl(C)
End If
Next

Application.ScreenUpdating = True
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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