Currently, there seems no way to select a "Natural Sort" in Excel.
This is how it sorts:
ID
1 2020-02-03 Phase 1: Planning
1.1 2020-02-03 Identify Project Team
1.2 2020-03-20 Project Charter
1.3 2020-07-07 Project Work Plan
1.4 2020-12-24 Project Kick-Off Meeting (emails)
2 2019-12-30 Phase 2: Implementation
2.1 2020-10-30 Review the Key Business Process (KBP) Inventory
2.10 2022-06-29 Tabletop/validation exercises
2.2 2021-06-03 Line 2: Tabletop Schedule
2.2.1 2020-12-24 Kick-off Email, tools and expectation
Notice 2.10 comes before 2.2. if we had an ID of 10.2, it actually shows up after 2.2, so the whole number is working EXCEPT for 2.21, and after the decimal, it is not in order either. Tried number, text, $, time formats in desperation. Any help would be appreciated. I just want it to show up as a TOC would.
Bookmarks