Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Sorting by date/Office 2010
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Other forums
- :
- Tech Help - Software/Hardware etc
- :
- Re: Sorting by date/Office 2010
Sorting by date/Office 2010
23-12-2013 6:25 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I have a form in Word 2010 that contains a date field. Wishing to sort by date I imported the form into Excel 2010 only to find that Excel doesn't know how to handle 19th century dates. Anyone have any ideas on how I can achieve the sort?
TIA
TIA
6 REPLIES 6
Re: Sorting by date/Office 2010
23-12-2013 6:57 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I remember reading somewhere that the free LibraOffice suite can handle pre-1900 dates if that may help.
Forum Moderator and Customer
Courage is resistance to fear, mastery of fear, not absence of fear - Mark Twain
He who feared he would not succeed sat still
Re: Sorting by date/Office 2010
23-12-2013 8:05 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Depends on the format of the date in Word I guess, just write your own macro to convert it to yyyymmdd as a number.
Bit more work if you're going BC of course.
Bit more work if you're going BC of course.
Re: Sorting by date/Office 2010
24-12-2013 3:25 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
In Excel, if your dates are input in the format dd/mm/yy you could format the dates column as "Date 2001-03-14" or "Custom yyyy-mm-dd". The data should then sort correctly - it does in Excel 2007 anyway.
Re: Sorting by date/Office 2010
27-12-2013 9:59 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Quote from: MrT In Excel, if your dates are input in the format dd/mm/yy you could format the dates column as "Date 2001-03-14" or "Custom yyyy-mm-dd". The data should then sort correctly - it does in Excel 2007 anyway.
Tried this. Either way it just sorts the 20th century dates and ignores the earlier ones.
Re: Sorting by date/Office 2010
27-12-2013 10:03 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
This explains how to get round it http://boards.straightdope.com/sdmb/showthread.php?t=333461 but it isn't nice
Re: Sorting by date/Office 2010
27-12-2013 11:09 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Sometimes it is possible to be too clever.
I took the approach of importing the table into Excel because a few years ago I wanted a table with numbered rows and that is what I was advised. Now, I remembered form/sorting/Excel and finished up here.
What I should have done is, in Word, clicked on layout/sort and choose the parameters, which did exactly what I wanted.
Thanks to those who replied.
I took the approach of importing the table into Excel because a few years ago I wanted a table with numbered rows and that is what I was advised. Now, I remembered form/sorting/Excel and finished up here.
What I should have done is, in Word, clicked on layout/sort and choose the parameters, which did exactly what I wanted.
Thanks to those who replied.
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Other forums
- :
- Tech Help - Software/Hardware etc
- :
- Re: Sorting by date/Office 2010