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?
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.
- How can I update previous object keys while iterating through a single loop?
- Converting a String to a List of Words?
- Output a list from a sentence and count characters for each word
- How to format a floating number to fixed width in Python
- Unknown character for Turkish character
- How do I append one string to another in Python?
- split string last delimiter
- When/ why would you use QUOTENAME in SQL?
- Method to capitalise the first letter of every word in a QString
- String Conversion error
- How to compare only first character of 2 strings (javascript)?
- converting hexadecimal string to decimal integer and vice-versa
- Building a string with array values
- parsing html to get content using c#
- Importing unquoted strings as factors using read_csv from the readr package in R
- Convert list of integers into a specific string format
- How to remove first & last character of a text?
- Java: Check if enum contains a given string?
- Swift How to get integer from string and convert it into integer
- Replace substring of NSAttributedString with another NSAttributedString
- How to index a String in Rust
- How to prevent automatic handling of newlines killing performance in Perl text output?
- getString Outside of a Context or Activity
- Splitting a string by a character
- C++: Read from text file and separate into variable
- Problems with adding the result of at() to a C++ string
- What's the best way to convert a number to a string in JavaScript?
- Trying to capitalize the first character in array of strings, why this is not working?
- Extracting string from ann email body
- javascript includes() case insensitive