stringtableau-apilong-integernumber-formattingscientific-notation

Tableau long number converting to scientific


I have a field which contains 50digits as a number format. In excel all 50 digits are displayed but when I load this to Tableau, the number gets converted in scientific format. I tried changing the data type of the field in Excel as Text and in Tableau I changed it to string but it still shows in scientific format. Excel:

7091053585214305444451810524505546820833

Tableau :

7.09105e+39

I want the field to be in string format and display all the digits.

Can anyone please suggest what can I do here?


Solution

  • If you change format of the date to text in excel then it will still retain the exp format, since you have access to excel data source, create a new column and change the format of the column to Text then copy the data into that column which will consider it as Text instead of Integer.

    enter image description here