Excel not sorting correctly (off of a formula)

This shows a possible cause (and fix) for sorting confusion when sorting off of a formula.