# Data Table and and number display

**URL:** <https://forum.inductiveautomation.com/t/data-table-and-and-number-display/1762>\
**Category:** Ignition\
**Created:** [April 15, 2010, 10:46pm UTC](https://forum.inductiveautomation.com/t/data-table-and-and-number-display/1762 "2010-04-15T22:46:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![kurt](https://avatars.discourse-cdn.com/v4/letter/k/b19c9b/32.png) [@kurt](https://forum.inductiveautomation.com/u/kurt)\
**Post date:** [April 15, 2010, 10:46pm UTC](https://forum.inductiveautomation.com/t/data-table-and-and-number-display/1762/1 "2010-04-15T22:46:04Z")

</div>

I have added a table to a Window and hooked the Data to a database. It displays some of the data correctly. Anthing less than .01 shows up as 0 in the table. I assume that this is the same problem that affects the charts. However, since 0.008 is not 0 I think this rises to the level of being a bug. The only thing worse than no data is wrong data. The data shows up correctly in the SQL Tags browser where I have changed the Format (in Metadata) to 0.00E00 but this only affects the screen display and apparently not the table display.

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [April 15, 2010, 10:49pm UTC](https://forum.inductiveautomation.com/t/data-table-and-and-number-display/1762/2 "2010-04-15T22:49:35Z")

</div>

The format string meta property is only used when you drag and drop a tag onto a display. The table by default formats a number with #,##0.##. So you want to right click on the component and go into the Table Customizer. Change the number format for the appropriate column to something like #,##0.##### or #,##0.00000. The number signs signify a decimal place may or may not be there. A zero says always show that many decimal places. Hope this helps.

---

<div class="post-metadata">

**Author:** ![kurt](https://avatars.discourse-cdn.com/v4/letter/k/b19c9b/32.png) [@kurt](https://forum.inductiveautomation.com/u/kurt)\
**Post date:** [April 16, 2010, 2:57pm UTC](https://forum.inductiveautomation.com/t/data-table-and-and-number-display/1762/3 "2010-04-16T14:57:12Z")

</div>

Yes that works. I will take back half the things I was thinking about you. If you fix the charts for scientific notation I will take back the other half.  
Thanks,  
Kurt

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [April 16, 2010, 4:19pm UTC](https://forum.inductiveautomation.com/t/data-table-and-and-number-display/1762/4 "2010-04-16T16:19:38Z")

</div>

For what its worth, anywhere that you can specify a number format pattern (like in the table’s column configs) you can get it to display scientific notation, using a number format pattern like this:  
[tt]0.###E0[/tt]