A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Office » General Discussions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Sorting by date in tables



 
 
Thread Tools Display Modes
  #1  
Old September 8th, 2008, 09:13 PM posted to microsoft.public.office.misc
Lita
external usenet poster
 
Posts: 6
Default Sorting by date in tables

I am preparing a medical chronology and using Microsoft Word 2007/table. I
have three columns; date/medical provider/ summary of visit. I need to sort
information by date. I highlighted all information and chose sort by column
A, then asked it sort by date, assending. It is not sorting all dates. It's
leaving my January 2008 date first every time, but sorting the rest properly.
I never had this problem in my old format of Word. The format I used for
my date is 01/14/2008. Any suggestions?
--
Lita Dale
  #2  
Old September 8th, 2008, 09:19 PM posted to microsoft.public.office.misc
Bob I
external usenet poster
 
Posts: 10,698
Default Sorting by date in tables

Perhaps you made a text entry instead of a real date?

Lita wrote:
I am preparing a medical chronology and using Microsoft Word 2007/table. I
have three columns; date/medical provider/ summary of visit. I need to sort
information by date. I highlighted all information and chose sort by column
A, then asked it sort by date, assending. It is not sorting all dates. It's
leaving my January 2008 date first every time, but sorting the rest properly.
I never had this problem in my old format of Word. The format I used for
my date is 01/14/2008. Any suggestions?


  #3  
Old September 8th, 2008, 09:27 PM posted to microsoft.public.office.misc
Herb Tyson [MVP]
external usenet poster
 
Posts: 3,614
Default Sorting by date in tables

Do you have a header row (i.e., that says Date/Provider/Summary or something
like that)? If not and if Header row is ticked, then sorting will treat the
first entry as if it were the header row, and will not include it in the
sort.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"Lita" wrote in message
news
I am preparing a medical chronology and using Microsoft Word 2007/table. I
have three columns; date/medical provider/ summary of visit. I need to
sort
information by date. I highlighted all information and chose sort by
column
A, then asked it sort by date, assending. It is not sorting all dates.
It's
leaving my January 2008 date first every time, but sorting the rest
properly.
I never had this problem in my old format of Word. The format I used for
my date is 01/14/2008. Any suggestions?
--
Lita Dale


  #4  
Old September 8th, 2008, 09:32 PM posted to microsoft.public.office.misc
Herb Tyson [MVP]
external usenet poster
 
Posts: 3,614
Default Sorting by date in tables

Also... I just noticed that you say you're sorting by "column A". If this
really is Word, then it would be column 1, not column A. Excel would say
Column A. And, if you're using Excel, then Bob I's guess might be more apt.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"Herb Tyson [MVP]" wrote in message
...
Do you have a header row (i.e., that says Date/Provider/Summary or
something like that)? If not and if Header row is ticked, then sorting
will treat the first entry as if it were the header row, and will not
include it in the sort.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"Lita" wrote in message
news
I am preparing a medical chronology and using Microsoft Word 2007/table.
I
have three columns; date/medical provider/ summary of visit. I need to
sort
information by date. I highlighted all information and chose sort by
column
A, then asked it sort by date, assending. It is not sorting all dates.
It's
leaving my January 2008 date first every time, but sorting the rest
properly.
I never had this problem in my old format of Word. The format I used
for
my date is 01/14/2008. Any suggestions?
--
Lita Dale



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.