Last Modified Date: 11 Oct 2019
- Tableau Desktop
Option 1Import the field as a number field rather than a string.
Option 2Force Excel to recognize the numbers as text using the TEXT() function in Excel. For example:
TEXT(<cell to convert>, "@")
CauseWhen importing large numbers as strings, Tableau Desktop forces these numbers into scientific notation.
Additional InformationTEXT function in Microsoft Office Support
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials