I read several threads but none of them really answered this question. I am exporting data from a table into Excel. The datatype in the table in question are MONEY (sorry, not my design). When I export to excel via an Export template, the money fields are stored as text in excel. This means I have to reformat them as numbers first, before doing additional calculations in excel.
The number fields in the table export fine. It’s just the Money fields that suffer from this issue. Anyone know how to fix this?