Number formatting

  • Question
  • Updated 3 years ago
Is there a way to change the way the data in tables is presented? I have some numbers in the millions and billions that would be significantly easier to read with spaces or commas. I need the field to remain as an integer however, for filtering capabilities.

Thanks!
Photo of Alyx Coulter

Alyx Coulter

  • 1 Post
  • 0 Likes

Posted 3 years ago

  • 1
Photo of EmilyE

Emily, Official Rep

  • 873 Posts
  • 19 Likes
Right now we can change how numbers are displayed in the info window but there is a trick if you want to try. Keep the column with you numbers in integer. Then create another column with the same numbers, with your commas but add some form of text in it like Number 2,000 or what ever you want. Then Geocommons will read it as text and keep the columns to display as such in the info windows.

Let me know if you need more help

Emily