# Table number formatting not working

**URL:** <https://forum.inductiveautomation.com/t/table-number-formatting-not-working/18287>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [June 4, 2018, 8:32pm UTC](https://forum.inductiveautomation.com/t/table-number-formatting-not-working/18287 "2018-06-04T20:32:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bfuson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bfuson/32/4597_2.png) [@bfuson](https://forum.inductiveautomation.com/u/bfuson)\
**Post date:** [June 4, 2018, 8:32pm UTC](https://forum.inductiveautomation.com/t/table-number-formatting-not-working/18287/1 "2018-06-04T20:32:34Z")

</div>

I have a dataset memory tag within a UDT that contains a row of integer indexes and a row of doubles:  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/a50cbe2a93b4056a708235e9eefd002b296ae626.png)

I’d like to render the doubles as percentages, and have setup the formatting as [follows](http://forum.inductiveautomation.com/t/numeric-text-field-units/2779/2):

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/44dbd4e6063fa8d402684e84847982155a255a1c.png)

However, the column doesn’t seem to follow that rule:  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/1/1f1e60beaa7b98a9bf02bbb878b4d1be7ba113f3.png)

What’s going on here?

---

<div class="post-metadata">

**Author:** ![zacslade](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacslade/32/3587_2.png) [@zacslade](https://forum.inductiveautomation.com/u/zacslade)\
**Post date:** [June 4, 2018, 9:12pm UTC](https://forum.inductiveautomation.com/t/table-number-formatting-not-working/18287/2 "2018-06-04T21:12:46Z")

</div>

I just tried this out, and I was able to format a column correctly with the percent sign and everything. The way I did it was using this as the format string:

> 0.00%

Note that I didn't put single quotes around the percent sign (%). I just appended it to the end of the string. However, just to make sure that I was doing it right, I put the percent sign in single quotes the way you did, and it divided all the values in my column by 100 and rounded the number to the nearest 100th place.

So maybe try it both ways?

---

<div class="post-metadata">

**Author:** ![bfuson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bfuson/32/4597_2.png) [@bfuson](https://forum.inductiveautomation.com/u/bfuson)\
**Post date:** [June 4, 2018, 9:32pm UTC](https://forum.inductiveautomation.com/t/table-number-formatting-not-working/18287/3 "2018-06-04T21:32:38Z")

</div>

No formatting option is working for my power table, not even the presets.

Found the issue: someone had overridden the getDisplayTextAt extension function on the table. 😰

Thanks for your help!