imported dates that excel will not recognise

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

I have imported a series of dates in the format 11/02/2011
however I can not reformat them to 11 February 2011 neither to my date
formulary work
 
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:
 
Back
Top