Hi,
My CSV file has too many rows to fit in a sheet, so I import it to the data model instead.
Then I can use it when I create a Pivot table (Create PivotChart - Use this workbooks Data Model).
The problem is the formatting of a column with numbers. Because "." is used as decimal separator the column is stored as text.
So when I open "Manage Data Model" and try to change Data Type to 'currency' I get an Type mismatch error.
How can I change the decimal separator for a column in the Data Model?
Bookmarks