I would like to store some reference data in the “sheet” format. But I sometimes need to work with numbers across several orders of magnitude and scientific notation is the best way to accommodate all. It seems that sheets cannot properly identify numbers in scientific notation and treat them more like string when sorting.
Is it possible to make scientific notation, such as 1.9e+10, behave like numbers in sheets?