View Single Post
 
Old 11-24-2014, 06:23 AM
freebird795 freebird795 is offline Windows 7 64bit Office 2013
Novice
 
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