info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Sorting by Dates in a Table
14 views
Skip to first unread message
Susan
Jun 9, 2004, 4:15:01 PM6/9/04
to
I have a table that has 4 columns in it, the first column
is filled in with all dates (in this format 1/3/04). I am
trying to sort the table by date, oldest to newest. I
selected the column, went to table, sort, sort by date.
It does not make any changes to the table. Any
suggestions??
is filled in with all dates (in this format 1/3/04). I am
trying to sort the table by date, oldest to newest. I
selected the column, went to table, sort, sort by date.
It does not make any changes to the table. Any
suggestions??
Suzanne S. Barnhill
Jun 9, 2004, 6:04:50 PM6/9/04
to
It sounds as if you're doing everything right. FWIW, it works perfectly for
me--even recognizing "99" as being earlier than "02," which I wouldn't
necessarily have expected. In my case, Word's default settings for Column 1
were Type: Date and Using: Paragraphs, so it obviously recognized the dates.
Is there any text in your first column other than the dates? BTW, although
it didn't appear to make any difference in my testing, you don't need to
select the column before going to Table | Sort: that dialog allows you to
select the desired column to sort on (by number or by name if you've added a
heading row) and adjusts the sort according to the content of the column.
me--even recognizing "99" as being earlier than "02," which I wouldn't
necessarily have expected. In my case, Word's default settings for Column 1
were Type: Date and Using: Paragraphs, so it obviously recognized the dates.
Is there any text in your first column other than the dates? BTW, although
it didn't appear to make any difference in my testing, you don't need to
select the column before going to Table | Sort: that dialog allows you to
select the desired column to sort on (by number or by name if you've added a
heading row) and adjusts the sort according to the content of the column.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
"Susan" <anon...@discussions.microsoft.com> wrote in message
news:1a1d501c44e5e$7181f090$a601...@phx.gbl...
Susan
Jun 10, 2004, 11:32:45 AM6/10/04
to
No, there is nothing else in the column, I looked at the
style of text, and even tried retyping the numbers, just
in case, I am at a loss ....
style of text, and even tried retyping the numbers, just
in case, I am at a loss ....
>.
>
Suzanne S. Barnhill
Jun 10, 2004, 3:50:03 PM6/10/04
to
I think I may have the glimmering of an idea. You and I are both assuming
that Word will recognize 1/3/04 as a date. But ISTR that this is true only
if you have used slashes in your default date format in Control Panel |
Regional Options | Date. If you've used hyphens or some other separator,
Word might not interpret the dates correctly. Just a wild guess and probably
irrelevant, since I just tested using dates with hyphens, and Word sorted
correctly (I guess if you tell Word they're dates, it responds accordingly).
So I guess we're no forrader. Sorry!
that Word will recognize 1/3/04 as a date. But ISTR that this is true only
if you have used slashes in your default date format in Control Panel |
Regional Options | Date. If you've used hyphens or some other separator,
Word might not interpret the dates correctly. Just a wild guess and probably
irrelevant, since I just tested using dates with hyphens, and Word sorted
correctly (I guess if you tell Word they're dates, it responds accordingly).
So I guess we're no forrader. Sorry!
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
"Susan" <anon...@discussions.microsoft.com> wrote in message
news:1ac5e01c44f00$2dc1dad0$a101...@phx.gbl...
Susan
Jun 11, 2004, 11:30:02 AM6/11/04
to
Thanks, I thought of that too and double checked with Word
help, it does recognize the slashes. I might do a find
and replace to hyphens just to rule it out though. Thanks
again.
help, it does recognize the slashes. I might do a find
and replace to hyphens just to rule it out though. Thanks
again.
Susan
>.
>
0 new messages