P
peturpin
How do I troubleshoot sorting dates in Word? I've already checked to make
sure I have forward slashes, but that didn't help.
sure I have forward slashes, but that didn't help.
C
Cindy M -WordMVP-
Hi =?Utf-8?B?cGV0dXJwaW4=?=,
Which country (USA, England, other) date format would you use?
Which country date format is set up in the Windows Control Panel?
Are you trying to sort dates in text, in a table, something else?
Finally, could you give us a few examples of the dates you're trying to sort,
for testing purposes?
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail
Version of Word?
Which country (USA, England, other) date format would you use?
Which country date format is set up in the Windows Control Panel?
Are you trying to sort dates in text, in a table, something else?
Finally, could you give us a few examples of the dates you're trying to sort,
for testing purposes?
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail
P
Peturpin
I believe that this is Microsoft Word from the Office 2003 Software Pack.
I tried using two different date formats that I've seen the the USA:
MM/DD/YY and MM-DD-YY.
The date format set up under Regional and Language Options in the Control
Panel is M/D/YYYY.
I am trying to sort dates in a table.
Examples of dates I'm trying to sort: 05/13/05, 06/07/05, etc.
If the date format is set up in the Control Panel as shown above, does that
mean that dates need to be listed in the same manner in Word in order to be
sorted correctly in tables?
Thank you for your time, I appreciate it.
Peturpin
--
Peter Turpin
Cultural Liaison
West Central Integration Collaborative
611 5 St SW
Rm 354
Willmar, MN 56201-3218
USA
(320) 231-8573
FAX: 1 (320) 231-8559
I tried using two different date formats that I've seen the the USA:
MM/DD/YY and MM-DD-YY.
The date format set up under Regional and Language Options in the Control
Panel is M/D/YYYY.
I am trying to sort dates in a table.
Examples of dates I'm trying to sort: 05/13/05, 06/07/05, etc.
If the date format is set up in the Control Panel as shown above, does that
mean that dates need to be listed in the same manner in Word in order to be
sorted correctly in tables?
Thank you for your time, I appreciate it.
Peturpin
--
Peter Turpin
Cultural Liaison
West Central Integration Collaborative
611 5 St SW
Rm 354
Willmar, MN 56201-3218
USA
(320) 231-8573
FAX: 1 (320) 231-8559
S
Suzanne S. Barnhill
I don't think so. If you set the sort type as Date (and often Word will
figure this out on your own), it should sort dates intelligently. Have you
tried it?
figure this out on your own), it should sort dates intelligently. Have you
tried it?
P
Peturpin
Yes, I have tried sorting according to date, but it sorts the entries
according to no identifiable order, or it doesn't sort them at all.
Thanks for your thoughts, I welcome any other questions or suggestions about
this.
Peturpin
--
Peter Turpin
Cultural Liaison
West Central Integration Collaborative
611 5 St SW
Rm 354
Willmar, MN 56201-3218
(320) 231-8573
FAX: 1 (320) 231-8559
according to no identifiable order, or it doesn't sort them at all.
Thanks for your thoughts, I welcome any other questions or suggestions about
this.
Peturpin
--
Peter Turpin
Cultural Liaison
West Central Integration Collaborative
611 5 St SW
Rm 354
Willmar, MN 56201-3218
(320) 231-8573
FAX: 1 (320) 231-8559
D
Doug Robbins
On my machine (Word 2003 on Windows XP) with the Control Panel short date
format set to M/d/yyyy, the following dates
05/13/2005
04/15/2005
07/02/2005
04/12/2005
get sorted correctly to
04/12/2005
04/15/2005
05/13/2005
07/02/2005
and spaces before or after a date do not prevent the sort from being
performed.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
format set to M/d/yyyy, the following dates
05/13/2005
04/15/2005
07/02/2005
04/12/2005
get sorted correctly to
04/12/2005
04/15/2005
05/13/2005
07/02/2005
and spaces before or after a date do not prevent the sort from being
performed.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP