When creating a pivot table, all of my data columns appear to be interpreted as text (rather than the various date and currency columns that I'm actually using). This prevents me from summing up values, for instance. I suspect that this is caused by the fact that I am using a Dutch locale in the Sheet settings. Is there a way to keep using the Dutch locale, but also have proper data types in a pivot table?

Kind regards