Hi Mike
For some reason the imported date is not interpreted as a true date by
excel. A couple of possibly reasons:
The date has leading or trailing spaces:
To remove spaces, use a helper column, where you enter this formula
=Trim(A1), (A1 is the date cell), copy down the formula. Now you can copy the
helper column and paste it into the original column as true dates using
PasteSpecial and paste values only.
The date is seen as a text.
In an unused cell enter 1, copy the cell, select the date column,
PasteSpecial > Multiply > OK.
Hopes this helps.
....
Per
"mike" skrev:
