3 Replies Latest reply on Dec 6, 2016 10:18 AM by David Li

    set default decimal places to 1

    gene shackman

      When I read in an excel file, many of the variables are numeric, with some decimal places. I want the numbers to show only one decimal place. I've rounded the numbers in excel so they only have one decimal place. But when I read it into Tableau, a bunch of extra zeros are added in. So my original data are like this

          

      IDVar1Var2
      11.12.1
      21.42.6
      33.21.8

       

      When I read it into Tableau, it looks like this

          

      IDVar1Var2
      11.100002.10000
      21.400002.60000
      33.200001.80000

       

       

       

       

       

      Do I have to format each column, to make it one decimal place? Is there a way to tell Tableau that I want the default to be 1 decimal place? If I have 5 or more variables, this wastes time, if I have to change each column individually.

       

      Thanks