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 do I escape curly-brace ({}) characters characters in a string while using .format?
- How to index a String in Rust
- golang - how to sort string or []byte?
- How can I map a String to a function in Java?
- Remove spaces from std::string in C++
- Python fuzzy search and replace
- Why is CompareTo() not recommended for checking equality?
- Get PythonTkinter width of string in pixels using given font
- convert C# date time to string and back
- How to convert DateTime to/from specific string format (both ways, e.g. given Format is "yyyyMMdd")?
- SQL Server : generate random numeric string 27 characters long
- How can I capitalize the first word of each sentence of a string in PHP?
- What is the easiest way to remove the first character from a string?
- What's the best borrowing accessor pattern for Optional<String>?
- How to insert a variable value in a string in python
- How can I concatenate strings in a cell array with spaces between them in MATLAB?
- How to use `string.startsWith()` method ignoring the case?
- Remove unwanted parts from strings in a column
- Find all the occurrences of a character in a string
- Serialize a JSON Object to Dictionary<string, string>
- Python - AttributeError: 'str' object has no attribute 'append'
- Splitting R string based on multiple criteria (data does not have a simple delineation like spaces or comma to separate by)
- Is there a way to preserve ANSI control codes in PowerShell command output?
- Should Polars Enum Datatype Result in More Efficient Storage and Memory Footprint of DataFrame?
- Converting from a string to boolean in Python
- Copy happened when pass char * to string?
- Why are python strings and tuples made immutable?
- How to remove duplicate white spaces in string using Java?
- How to convert a String into an ArrayList?
- Extract substring between given strings