Last Modified Date: 07 Mar 2024
Environment
- Tableau Desktop
- Excel
Resolution
Option 1
Import the field as a number field rather than a string.Option 2
Force Excel to recognize the numbers as text using the TEXT() function in Excel. For example:TEXT(<cell to convert>, "@")
Option 3
In the Excel sheet, set the target field as TEXTand then create another column ("Test2" here) with function CLEAN().
Use TYPE() function ("Type Test 2" here) to confirm all the row values have the same type as 2.
Cause
When importing large numbers as strings, Tableau Desktop forces these numbers into scientific notation.Additional Information
TEXT function in Microsoft Office Support.Excel "Text" function does not work as expected. Still some rows are considered to be number even set as "Text". As a result, Tableau receives an exponential string.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials