In CRM I have custom fields holding currency amounts. When these are exported to sheets, they are transformed to text so I am unable to sum etc. I cannot find a way to reformat to numbers. How can I keep them as numbers?

Thanks