Twenty Two Years And Counting.
ChatterBank5 mins ago
MS Excel
2 Answers
Hi, does anybody know if there's a way to get dates from before 01/01/1900 to display as dates, rather than text?
As an example of what I'm trying to do, I have a worksheet with the names of everybody who's ever played for England. If I want to sort it by number of matches, goals scored, etc. no problem. But I cant sort it on the order in which they played their first game, because any dates before 1900 aren't recognised.
01/01/1900 is the start of history as far as Microsoft are concerned.
As an example of what I'm trying to do, I have a worksheet with the names of everybody who's ever played for England. If I want to sort it by number of matches, goals scored, etc. no problem. But I cant sort it on the order in which they played their first game, because any dates before 1900 aren't recognised.
01/01/1900 is the start of history as far as Microsoft are concerned.
Answers
1 to 2 of 2
Best Answer
No best answer has yet been selected by SeaJayPea. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.1 to 2 of 2
