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 recognise the numbers as text using the TEXT() function in Excel. For example:TEXT(<cell to convert>, "@")
Cause
When importing large numbers as strings, Tableau Desktop forces these numbers into scientific notation.Additional information
TEXT function in Microsoft Office Support
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