We use a number system like software versioning or IP addresses for business requirements, using decimal points to separate significant number sets.Spreadsheets don't handle this well because when doing 1.8, 1.9, 1.10, 1.11 it treats these numbers as decimals and 1.10 is equal to 1.1.I want to be able to type and sort these numbers without sheets auto-formatting important information away.
Sortable Version/Requirement Numbering in Google Sheets
google spreadsheets