A work around is to highlight the columns individually, Data>Text to Columns>Finish. Its annoying to have to manually highlight each column but its better than ...
Having this same issue and Microsoft indicated that they believe the issue is from QuickBooks and they do not support this issue. Since file is opening in excel...
