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.
- Change toUpperCase() all except those within single quotes
- Multiline C# interpolated string literal
- Is there a clever way to convert a compex string to multiple lists in Python 3
- Counting Substrings from a List, inside a String
- How can I find all matches to a regular expression in Python?
- String cleaning removing consecutive value and put comma in the end
- EXCEL: Count all unique values in Table column up to a certain point, and combine them into a single string?
- Generate random string/characters in JavaScript
- How to pass empty string to bash for loop
- Why can't the switch statement be applied to strings?
- Expand a dataframe row into multiple rows based on string conditions
- How do I truncate a .NET string?
- How do I print my Java object without getting "SomeType@2f92e0f4"?
- Truncate a string to first n characters of a string and add three dots if any characters are removed
- Best way to compare std::strings
- Convert a string into unicode escape sequences
- Parse hex string to image/color
- Parse query string into an array
- How can I replace every instance of a character from 3 groups of characters with just 3 different characters respectively?
- How to get a variable value if variable name is stored as string?
- Integer to IP Address - C
- What method in the String class returns only the first N characters?
- Finding the string length of a integer in .NET
- advantage of QString over std::string
- Find out if Character in String is emoji?
- Making a Histogram using an Array of integers
- How can I abbreviate phrases using Polars built-in methods?
- How do I convert a Go array of strings to a C array of strings?
- How to cast a String as an Array then dedupe Array in Java?
- Splitting a string that is delimited by multiple delimiters (regex)