4 Replies Latest reply on Jul 24, 2017 8:37 AM by alex.zapherson

    Converting Scientific Notation to Standard (Excel File Data Source)

    alex.zapherson

      I am using an Excel file as a data source in which I have an ID that is 10 digits long, however Tableau is converting this to scientific method. I have tried converting this to a number when bringing it into tableau but because some of the ID's have letters in them there is nothing showing up when I convert. I have also tried numerous fixes in excel such as changing the formatting or using formulas to convert to text but nothing seems to work. Is there any other work arounds anyone is aware of?