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

Published: 24 May 2019
Last Modified Date: 02 Oct 2020


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.


  • Tableau Desktop
  • Google Sheets


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.


This was a known issue (ID: 820202) that was fixed in more recent versions of Tableau Desktop.
Did this article resolve the issue?