date in text format as a real date

[Mortir]

I have a date that is in text format 12.01.08 (dd.mm.yy). However I
cant convert it to a real date which can be used for further
operations. The format cell - date does not work... Thanks for your
help

 

[Mike H]

Try

Select your date then

data|text to columns
Select fixed width
Next
Next
Select date D/M/Y
Finish

Mike

 

[Gord Dibben]

Data>Text to Columns>Next>Next>Column Data Format>Date>DMY and Finish.


Gord Dibben MS Excel MVP