Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-24-2014, 06:23 AM
freebird795 freebird795 is offline Unable to sort dates in Excel on new PC Windows 7 64bit Unable to sort dates in Excel on new PC Office 2013
Novice
Unable to sort dates in Excel on new PC
 
Join Date: Nov 2014
Location: Cheshire, UK
Posts: 2
freebird795 is on a distinguished road
Default Unable to sort dates in Excel on new PC


Hope somebody can help as this is driving me doolally-tap.

We have an access database at work which produces reports in Excel; install dates, closure dates, etc.

Everything worked fine until last week when I received a new laptop. Since then I cannot sort things by date, unless I convert them to values, etc.

A typical 'sorted' list looks like this:
01/12/2014
03/11/2014

03/12/2014
05/01/2015

08/12/2014

18/08/2014
Everybody else can sort them correctly. Nothing has changed on the database or any of the templates that we use. It would appear to be something on my copy of Excel. I've gone through the menus and options and can't find anything.

Any help is much appreciated.
Reply With Quote
  #2  
Old 11-24-2014, 06:52 AM
freebird795 freebird795 is offline Unable to sort dates in Excel on new PC Windows 7 64bit Unable to sort dates in Excel on new PC Office 2013
Novice
Unable to sort dates in Excel on new PC
 
Join Date: Nov 2014
Location: Cheshire, UK
Posts: 2
freebird795 is on a distinguished road
Default

Just as an update:

If I send a file to anybody else, they can sort it with no issues, so it must be something on my copy of Excel
Reply With Quote
  #3  
Old 11-26-2014, 05:58 PM
thetraininglady thetraininglady is offline Unable to sort dates in Excel on new PC Windows 7 64bit Unable to sort dates in Excel on new PC Office 2010 32bit
Competent Performer
 
Join Date: Sep 2014
Location: Sydney, Australia
Posts: 214
thetraininglady is on a distinguished road
Default

Sometimes sorting can be affected by the locale setting of your computer. Go into the Control Panel and into Regional Settings/Regional options and check which location you have setup in there. Check it against your colleagues computers who are not having the same issue.
Reply With Quote
  #4  
Old 12-07-2014, 03:06 PM
PeteNC PeteNC is offline Unable to sort dates in Excel on new PC Windows 7 64bit Unable to sort dates in Excel on new PC Office 2007
Novice
 
Join Date: Dec 2014
Posts: 4
PeteNC is on a distinguished road
Default Check your formatting

It appears as though the dates are in an order that would indicate they are being treated as text instead of dates. Have you sent the others a copy of your worksheet, or are they using the same worksheet that may still have the date format for that column?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL will not sort texascpa Excel 6 04-17-2013 07:58 AM
Unable to sort dates in Excel on new PC Simple Excel sort did not work correctly Spideriffic Excel 1 09-06-2012 04:40 AM
sort data in excel cabot Excel 1 08-17-2012 09:41 AM
Unable to sort dates in Excel on new PC Is this sort of pivot possible in the Excel? Jamal NUMAN Excel 4 02-14-2012 02:48 PM
Excel sort problem jaz Excel 2 01-16-2011 04:24 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 06:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft