I have a user with a query from an SQL Database that returns a series of string in this form:
000123123.23000
000123123.23000
000123123.23000
000123123.23000
000123123.23000
These are really numbers, however they cannot be summed. The correct way to fix this might be to cast the data in the SQL query, but then the Excel query viewer can't display it. As a workaround I do
= <CELL> +1 -1.
Is there a more elegant solution?