2 Replies Latest reply on May 28, 2013 7:05 AM by Sarah Connors

    Number formatting?

    Sarah Connors

      Is there a way to format numbers (in tableau 7) so that spaces separate the thousands instead of commas?

       

      Right now I have two columns in a table that I am trying to change from:

       

      123,456,789 to 123 456 789

      and

      123,456 to 123 456

       

      When I use custom number formatting and input 000 000 000, the first number changes as I want it to, but the second number gets a set of extraneous zeroes in front of it (000 123 456). Is there an easy way to fix this?

       

      Thanks!