KNOWLEDGE BASE

Importing Large Number as a String Results in Scientific Notation


Published: 13 Nov 2015
Last Modified Date: 02 Jun 2017

Issue

When importing a large number from Excel as a string, Tableau Desktop automatically converts these numbers into scientific notation format.

Environment

  • Tableau Desktop 9.0.0
  • 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>, "@")

Cause

When importing large numbers as strings, Tableau Desktop forces these numbers into scientific notation.

Additional Information

TEXT function in Microsoft Office Support

 

Did this article resolve the issue?