Data Text to Columns Next Next Under Column data format select Date,
in the drop down select DMY

"jjuan" wrote:

i have a date format like this - 13.02.2007(dd.mm.yyyy)
i like to convert it to date so that i can sort it by date.
i already used the format cells to change the category type to date but
nothings happen.
i also replace the dot(.) to slash(/) but the excel read it as mm.dd.yyyy

can someone give me a tips?
thanks!