I have a VERY simple report that all I want it to do is display the numbers from a table EXACTLY as formatted and be able to export them to Excel, as NUMBER (not STRINGS).
My fields may contains the following values in a single column:
And I want them to be displayed as entered in the source table.
Initially, to maintain the formatting, I set the field's data type to a STRING.
The problem is that when I then export the data to Excel, all the numerical values are treated as TEXT and we need to "Convert Text to Numbers".
When I changed the field's data type to a DOUBLE, the data in the table is correct, but the report formats all the numbers in one way. I want to be able to retain the formatting of the field (as-is) but have them exported as numbers, rather than text.
Can this be done?