Forum Discussion
Solved
.CSV export incorrectly converting text to date
I am exporting data from my .pbix to .csv but some of my hyphenated part IDs (field is text in Powr Query) are being converted into dates. Here's the .csv Part ID shown as a date: Here's ...
amitchandak, WordPad shows that it's exporting correctly. It's only when I open in Excel that it coverts. I'll try to use the import wizard in Excel to better control the data types.
Are you opening CSV in excel? If so please open it in Textpad and check. Excel might convert this.
amitchandak, WordPad shows that it's exporting correctly. It's only when I open in Excel that it coverts. I'll try to use the import wizard in Excel to better control the data types.
That did it. Thanks for walking me through the thought process.
Excel will treat is as text when it starts with '. But not sure the same is true when you export it like '2010-02-02