KNOWLEDGE BASE

Numbers Converted to Strings when Exporting to Crosstab


Published: 08 Aug 2014
Last Modified Date: 02 Jun 2016

Issue

When you export a view as a crosstab from Tableau Server, numbers that use a comma as a thousand separator (such as 1,200) might be converted to strings in Microsoft Excel.

Environment

  • Tableau Server
  • Microsoft Excel
  • Non-US locale setting for the Tableau Server user

Resolution

  1. In Microsoft Excel, select the column that contains the strings that should be numbers, and then open the Find and Replace dialog box. 
  2. In the Find and Replace dialog box, make the following selections, and then click Replace All.
    • For Find what, press ALT and type 0160, using the number keypad.
    • For Replace with, leave the field blank.
The incorrectly formatted strings are replaced with numbers.

Cause

In certain locales, thousand separators are exported from Tableau Server as non-breaking spaces. When Microsoft Excel encounters a thousand separator in a number that is denoted by a non-breaking space, it treats that number as a string.
Did this article resolve the issue?