8 Replies Latest reply on Nov 19, 2017 6:33 PM by Deepak Rai

    converting crosstab download date in toa recognisable excell date format - help!!

    joe Christie

      HI

       

      I am new to Tableau soi am finding it difficult to find my way around date formatting when downloading a crosstab. My problem is the date format from Tableau, example below,

      January 8, 2016

      cannot be completely converted to a recognisable excel date format. I have tried to use the 'Text to Column' functionality in excel but it doesn't  convert all rows in a column for  some reason. for example the mothns of July and September remain in a text format. Any help in getting round this would be greatly appreciated.

       

      thanks

       

      Joe