Forum Discussion

tbauch's avatar
tbauch
Frequent Visitor
6 years ago
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 ...
Need Help
  • tbauch's avatar
    tbauch
    6 years ago

    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. 

tbauch's avatar
tbauch
Frequent Visitor
6 years ago

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. 

amitchandak's avatar
amitchandak
Super User
6 years ago

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