date in text format as a real date

M

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
 
M

Mike H

Try

Select your date then

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

Mike
 
G

Gord Dibben

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


Gord Dibben MS Excel MVP
 
Top