an odd date format...

  • Thread starter Thread starter acb
  • Start date Start date
A

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
 
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
Click to expand...

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




--ron
 
Back
Top