Last Modified Date: 23 Dec 2016
- Tableau Desktop 9.0.0
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
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials