sort column in date order dd/mm/yy
 

In Excell I am trying to sort a column of dates dd/mm/yy, but it only seems
to sort on the first 2 digits. I have formatted the cells to date, but it
still does not seem to work

Can you help?

K

Are you sure that they're dates?

If you format those cells as: mmmm dd, yyyy
do they change to a long date format?

If they stay like dd/mm/yy, then your values aren't really dates--they're text
masquerading as dates.

If you select that columns of false dates, you can convert them to real dates by
using:

Data|text to columns
choose dmy as the format for that field.



K wrote:

In Excell I am trying to sort a column of dates dd/mm/yy, but it only seems
to sort on the first 2 digits. I have formatted the cells to date, but it
still does not seem to work

Can you help?

K

--

Dave Peterson

Very useful info as I imported data from Access, it only gives me date in
text masquerading. Although I know how to change it under format cell or
format painter but only one cell each time which was a big pain for me,
thanks a lot

Jennifer


"Dave Peterson" wrote:

Are you sure that they're dates?

If you format those cells as: mmmm dd, yyyy
do they change to a long date format?

If they stay like dd/mm/yy, then your values aren't really dates--they're text
masquerading as dates.

If you select that columns of false dates, you can convert them to real dates by
using:

Data|text to columns
choose dmy as the format for that field.



K wrote:

In Excell I am trying to sort a column of dates dd/mm/yy, but it only seems
to sort on the first 2 digits. I have formatted the cells to date, but it
still does not seem to work

Can you help?

K

--

Dave Peterson

If the "dates" are in one column, did you try the data|text to columns
technique?

If the dates are all over the place, maybe you can just
select your cells
edit|replace
what: / (slash)
with: / (slash)
replace all.



jen wrote:

Very useful info as I imported data from Access, it only gives me date in
text masquerading. Although I know how to change it under format cell or
format painter but only one cell each time which was a big pain for me,
thanks a lot

Jennifer

"Dave Peterson" wrote:

Are you sure that they're dates?

If you format those cells as: mmmm dd, yyyy
do they change to a long date format?

If they stay like dd/mm/yy, then your values aren't really dates--they're text
masquerading as dates.

If you select that columns of false dates, you can convert them to real dates by
using:

Data|text to columns
choose dmy as the format for that field.



K wrote:

In Excell I am trying to sort a column of dates dd/mm/yy, but it only seems
to sort on the first 2 digits. I have formatted the cells to date, but it
still does not seem to work

Can you help?

K

--

Dave Peterson


--

Dave Peterson