Link to home
Start Free TrialLog in
Avatar of mrmyth
mrmythFlag for United States of America

asked on

Word 2010 Table Sorting

Table has a "Date" column and we are sorting by that date. The dates don't seem to be sorting exactly by date.

What are the rules for sorting by date? Do the dates have to be in a very specific format? Do they, for instance have to be xx/xx/xxx?

If there is 1/5/2013 does it need to be 01/05/2013 in order to sort?
SOLUTION
Avatar of Steven Harris
Steven Harris
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mrmyth

ASKER

I am using the setting you have pictured above but with a header row, the date column just says DATE as a header.
So you notate it has a header row with the radio buttons, right?

Still not working properly?
Avatar of Paul Sauvé
Is the date dd/mm/yyyy or mm/dd/yyyy (as posted above by ThinkSpaceSolutions)?User generated imageDoesn't seem to work!
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mrmyth

ASKER

thank you!