I have a Pivot table in Excel with a column representing the week number. If I do sort in Alphabetical order I will get 1, 10, 11, 12 ... 2, 20, 21 etc.
我在Excel中有一个数据透视表,其中一列代表周数。如果按字母顺序排序,我会得到1分,10分,11分,12分...... 2分,20分,21分等。
This is not making sense. How can I get a 1,2,3,4... order?
这没有意义。我如何获得1,2,3,4 ...订单?
I was looking into creating a "custom filter" with no success.
我正在研究创建一个没有成功的“自定义过滤器”。
Any help? Thanks
有帮助吗?谢谢
1 个解决方案
#1
0
Make sure your source data column is formatted as General:
确保您的源数据列格式为General:
- Go to source data
- Right-click on column
- Select Format Cells
- Select General
- Click OK
转到源数据
右键单击列
选择格式单元格
If you get green arrows in the upper left corner of each cell, then convert the text to numbers:
如果每个单元格的左上角都有绿色箭头,则将文本转换为数字:
- Click on the first cell
- Drag the mouse down to the last cell (it won't work if you use keyboard shortcuts like shift+ctrl+down)
- Click the yellow diamond icon
- Select "Convert to Number"
单击第一个单元格
将鼠标向下拖动到最后一个单元格(如果使用shift + ctrl + down等键盘快捷方式,则无效)
单击黄色菱形图标
选择“转换为数字”
After you have accomplished the above, refresh your pivot table and sort the field.
完成上述操作后,刷新数据透视表并对字段进行排序。
#1
0
Make sure your source data column is formatted as General:
确保您的源数据列格式为General:
- Go to source data
- Right-click on column
- Select Format Cells
- Select General
- Click OK
转到源数据
右键单击列
选择格式单元格
If you get green arrows in the upper left corner of each cell, then convert the text to numbers:
如果每个单元格的左上角都有绿色箭头,则将文本转换为数字:
- Click on the first cell
- Drag the mouse down to the last cell (it won't work if you use keyboard shortcuts like shift+ctrl+down)
- Click the yellow diamond icon
- Select "Convert to Number"
单击第一个单元格
将鼠标向下拖动到最后一个单元格(如果使用shift + ctrl + down等键盘快捷方式,则无效)
单击黄色菱形图标
选择“转换为数字”
After you have accomplished the above, refresh your pivot table and sort the field.
完成上述操作后,刷新数据透视表并对字段进行排序。