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.
- Whats wrong with my tag-content-extractor program in java (hackerrank)?
- Best way to resolve file path too long exception
- Count number of characters in each row and drop if all are below a certain number
- Splitting a String into Smaller Parts based on Parens
- Convert List<List<String>> to a List<String>
- Prevent new-line characters in a multiline raw string literal
- How do I put variables inside javascript strings?
- How can I determine if a string contain all characters in character mask as a continuous substring?
- Python Tkinter: Create a variable for each string inside a listbox?
- Swift - check if attributed text is empty
- PHP Cleaning special characters from string
- Powershell replace spaces and special characters with hyphen
- How do I check to see if an object implements ->__toString() in PHP?
- How do I read / convert an InputStream into a String in Java?
- C re-initializing a variable after using strtok
- Return elements from a list that match a pattern
- Simpler way to check if string start with a digit in Rust?
- How to speed up pandas string function? Why is .str slower than .apply(lambda)?
- Using String variable as an expression
- Where are string constants stored by GCC and from where these pointers are mapped?
- How many bytes does one Unicode character take?
- How to name algorithm in c++ for process items in collection which can add or remove items?
- Iterating over strings
- Convert hex string to binary string
- Does Java have any equivalent to C++ string_view?
- Case insensitive comparison of strings in shell script
- Inserting char string into another char string
- How can I split a string into segments of n characters?
- How can I escape double quotes in a string?
- Most efficient way to remove special characters from string