如何按日期排序excel？ [英] How to sort by dates excel?

问题描述

这是最可笑的事情，但是我有麻烦的按日期排序excel。我有一列日期，以下列格式出现：

This is the most ridiculous thing, but I'm having trouble sorting by date in excel. I have a column of dates that I put in for something, in the following format

14/6/2012
15/12/2012
16/2/2012
17/9/2012
17/10/2012
17/11/2012

等等。然而，当我尝试排序它们时，它只按照上面显示的第一个数字进行排序。当我突出显示数据时，在excel的窗口顶部，它不会说一般的日期，所以我认为excel知道他们是日期。但是，如果我去排序和过滤，尝试选择几个不同的级别进行排序，当我尝试按日期排序时，它将A排序到Z，这似乎是奇怪的。然后当我将日期列复制并粘贴到一个新的工作表中以便玩弄它时，尝试弄明白出了什么问题，几个条目变成哈希，只是######，但只有少数条目那个和他们都分组在一起。

And so on like that. However when I try and sort them, it only sorts based on the first number, as I've shown above. When I highlight the data, at the top of window in excel, it doesn't say general anymore it says date so I assume excel knows that they're dates. However if I go to sort and filter to try and choose a few different levels to sort on, when I try to sort by the date it says sort A to Z, which seems odd. Then when I copied and pasted the date column to a new worksheet to play around with it to try and figure out what was wrong, several of the entries turned into hashes, just ######, but only a handful of entries did that and all of them are grouped together.

有谁知道可能是错的？这真的是我疯狂的，应该是最简单的事情。

Does anyone know what could be wrong? This is literally driving me insane, it should be the simplest thing.

推荐答案

散列只是因为你的列宽不够显示号码。

The hashes are just because your column width is not enough to display the "number".

关于排序，您应该查看如何配置系统区域和语言。对于美国地区，Excel日期输入应为5/17/2012而不是17/05/2012（此17-may-12）。

About the sorting, you should review how you system region and language is configured. For the US region, Excel date input should be "5/17/2012" not "17/05/2012" (this 17-may-12).

这篇关于如何按日期排序excel？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！