Why is Monday the last row of excel sort

The same column, from Monday to Friday, after the point sort order is Tuesday, Wednesday, Thursday, Friday, Monday, why Monday at the end?

Will be Tuesday, Wednesday, Thursday, Friday, Monday, to change for the week 2, week 3, week 4, week 5, week 1, on it.because the system does not recognize text of one, two, three, four, five.

Thank you!

Is in accordance with the alphabet row zhouer, zhousan, zhousi, zhouwu, zhouyi if you want to order, then, can the Tools, Options, custom list, which, to Monday, Tuesday ……input into the order, add, OK , and then sort like a

sort of text, excel defaults to the pronunciation of alphabetical order.the first word of the first sort, then sort the second word:er (2), san (three), si (4 ), wu (5), yi (1)

is the sort of it by spelling!

not you see me, as “Week” the same, according to a second alphabetical order.

you can define a sequence of their own, so this problem does not occur