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

Thanks for the reply, amitchandak. If you look at my post, you can see that the data is already formatted as text.

 

As shown in OP:

The "ABC" indicates it's text

 

 

It appears that the conversion is taking place during the export process. 

amitchandak's avatar
amitchandak
Super User
6 years ago

Are you opening CSV in excel? If so please open it in Textpad and check. Excel might convert this.

  • 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. 

    • tbauch's avatar
      tbauch
      Frequent Visitor
      6 years ago

      That did it. Thanks for walking me through the thought process. 

    • 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