7 Replies Latest reply on Feb 26, 2012 5:59 PM by Shawn Wallwork

    Excel Numbers Misbehaving

    April Hoy

      Strictly speaking, my problem is with my underlying spreadsheet, not with Tableau.  Hopefully someone can still help.

       

      I have a massive table of immigration data (see World Origins in attached).  The numbers in the Number of Refugees column are refusing to sort properly, and when I try to play with them in Tableau, it treats them as text rather than numbers.  Highlighting the column and resetting it to Number isn't helping.

       

      Any ideas?