KNOWLEDGE BASE

Long Number Values (built from a function in Google Sheets) are Displayed as Scientific Notation


Published: 24 May 2019
Last Modified Date: 24 May 2019

Issue

When a column in Google Sheets is formatted as a plain text number, long number values in the column are displayed as scientific notation in Tableau Desktop.

Environment

  • Tableau Desktop
  • Google Sheets

Resolution

Option 1

Upgrade to Tableau Desktop 10.3.21, 10.4.17, 10.5.16, 2018.1.13, or a newer version. For more information, see Upgrade Tableau Desktop.

Option 2

Add a space to the end of the numbers in their column in Google Sheets.

Option 3

Manually copy and paste the numbers into the necessary sheet instead of using a function such as IMPORTRANGE.

Option 4

Download the sheet as a .csv file and connect to that file in Tableau Desktop.

Cause

This was a known issue (ID: 820202) that was investigated by Tableau Development.
Did this article resolve the issue?