Excel file has values as text

🚧 THIS IS A TICKET MIGRATED FROM UPVOTY. The original ticket and comments will be available for a limited time over at:
https://abrp.upvoty.com/b/report-a-bug/excel-file-has-values-as-text/
———————————————————————————
For example, the cells in the “Cost” column cannot be summed or used as inputs to calculations. To reproduce, create an Excel file, go to an unused cell, type =SUM( and drag across all the leg costs. You won’t get the trip cost summed.