I have a CSV file for a dimension that Im trying to import. Many of the columns contain both numeric and text values.

For some reason when I try to import it to PowerPivot, those columns are always set to numeric columns, and the text values are omitted. I try to update the columns to text data type and refresh the values, but the cells that should contain text stay empty.

Any ideas on what Im doing wrong?