an odd date format...

[acb]

i have a data file in which the date column has a strange
format.
dd.mm.yy
when i sort, my result is incorrect because excel is not
recognizing that the day precedes the month. how can i fix
this?
thanks!
acb

 

[Ron Rosenfeld]

i have a data file in which the date column has a strange
format.
dd.mm.yy
when i sort, my result is incorrect because excel is not
recognizing that the day precedes the month. how can i fix
this?
thanks!
acb

Select the Date column
Data/Text to Columns
Fixed Width
Next
Column Data Format/Date/DMY
Finish




--ron