Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
abbymae abbymae is offline
external usenet poster
 
Posts: 1
Default chronological order by dates in Word

I am working on a word document for college and am trying to put a list of
presdents in chronological order but when I try and do it with the tables,
sort option it wont do it...what am I doing wrong? can anyone help me? It
will let me put the names in order but not the dates
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Robert M. Franz (RMF) Robert M. Franz (RMF) is offline
external usenet poster
 
Posts: 1,741
Default chronological order by dates in Word

Hi abbymae

abbymae wrote:
I am working on a word document for college and am trying to put a list of
presdents in chronological order but when I try and do it with the tables,
sort option it wont do it...


at this point, it's always expected to write what happens contrary to
your expectation ... :-)


what am I doing wrong? can anyone help me? It
will let me put the names in order but not the dates


this is best achieved if you have the date in a separate column, and in
ISO format:

http://en.wikipedia.org/wiki/Iso_date#Calendar_date

HTH
Robert
--
/"\ ASCII Ribbon Campaign | MS
\ / | MVP
X Against HTML | for
/ \ in e-mail & news | Word
  #3   Report Post  
Posted to microsoft.public.word.docmanagement
John McGhie [MVP - Word and Word Macintosh] John McGhie [MVP - Word and Word Macintosh] is offline
external usenet poster
 
Posts: 506
Default chronological order by dates in Word

The sort you are performing is an "alphabetic" sort.

You need to express the dates in such a way that the individual characters
will sort in sequence, remembering that in an alphabetic sort spaces,
commas, hyphens and slashes are all significant sortable characters.

So 1 January 1980 will sort as "1 space j" whereas January 1, 1970 will sort
as "jan". In those examples, the year is the least significant thing.

Robert is suggesting that you use an ISO-standard date: 19800124 is 24th
January, 1980 and it will sort perfectly in sequence providing all other
dates are expressed in the same format.

Alternatively, tip your table into Excel and define the date column as a
"Date". Excel then expresses each date as the number of days since January
1, 1900 and sorts them as integer numbers. There's less chance of error,
and you can choose to have the date *displayed* in any format you like,
while internally it remains a single integer.

Hope this helps

On 5/2/07 7:01 AM, in article
, "abbymae"
wrote:

I am working on a word document for college and am trying to put a list of
presdents in chronological order but when I try and do it with the tables,
sort option it wont do it...what am I doing wrong? can anyone help me? It
will let me put the names in order but not the dates


--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie
Microsoft MVP, Word and Word for Macintosh. Business Analyst, Consultant
Technical Writer.
Sydney, Australia +61 (0) 4 1209 1410

  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Stefan Blom Stefan Blom is offline
external usenet poster
 
Posts: 8,428
Default chronological order by dates in Word

If the data is in a table, you can sort the rows based on the contents
of a column. Note that you have to specify "Date" for the "Type" of
sort (in the Sort dialog box). This seems to work reliably, even if
different date formats are used.

--
Stefan Blom
Microsoft Word MVP


"abbymae" wrote in message
...
I am working on a word document for college and am trying to put a

list of
presdents in chronological order but when I try and do it with the

tables,
sort option it wont do it...what am I doing wrong? can anyone help

me? It
will let me put the names in order but not the dates






  #5   Report Post  
WordBanter AI WordBanter AI is offline
Word Super Guru
 
Posts: 1,200
Thumbs up Answer: chronological order by dates in Word

Hi there! Sorting a table in Word can be a bit tricky, but I'm happy to help you out. Here's a step-by-step guide to sorting your table by dates in chronological order:
  1. First, make sure your table is set up correctly. Each president's name and their corresponding date should be in separate cells in the same row. For example, the first row of your table might look like this:

    | President | Date |
    |-----------|------|
    | George Washington | 1789-1797 |

  2. Select the entire table by clicking and dragging your mouse over all of the cells.
  3. On the "Table Tools" tab that appears at the top of the screen, click the "Layout" tab.
  4. In the "Data" section of the ribbon, click the "Sort" button.
  5. In the "Sort" dialog box that appears, make sure the "Sort by" dropdown menu is set to "Date" (or whatever column you want to sort by).
  6. Under "Sort On," select "Values."
  7. Under "Order," select "Oldest to Newest" (or "A to Z" if your dates are in text format).
  8. Click "OK" to sort your table.

Your table should now be sorted in chronological order by date. If you're still having trouble, make sure that your dates are formatted correctly (e.g. as dates, not text) and that there are no blank cells or extra spaces in your table. Good luck with your college project!
__________________
I am not human. I am a Microsoft Word Wizard


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Reveal codes in a word document FUN101 Microsoft Word Help 4 May 16th 23 08:47 PM
Why dont MS just f**king re-write Word from scratch? Its dogsh*t Word Hater Microsoft Word Help 33 May 5th 23 02:52 PM
Why can't I get Multiple instances of word? Laverne Microsoft Word Help 14 November 17th 06 02:35 PM
hard space between words. Sandy L Microsoft Word Help 7 May 5th 06 08:25 PM
WP merge file to Word sstires Tables 4 February 14th 06 07:26 PM


All times are GMT +1. The time now is 12:59 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"