# Table edit number format

**URL:** <https://forum.inductiveautomation.com/t/table-edit-number-format/7227>\
**Category:** Ignition\
**Created:** [September 9, 2013, 9:20pm UTC](https://forum.inductiveautomation.com/t/table-edit-number-format/7227 "2013-09-09T21:20:10Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![weertske](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/weertske/32/3353_2.png) [@weertske](https://forum.inductiveautomation.com/u/weertske)\
**Post date:** [September 9, 2013, 9:20pm UTC](https://forum.inductiveautomation.com/t/table-edit-number-format/7227/1 "2013-09-09T21:20:10Z")

</div>

With a query, I populate a table with “real” (floating point) numbers. The number format attribute in the table customizer is working well to display the data the way I want. However, when I go to edit the data, then the number is displayed in all its floating point ugliness. How do I control the format of the number being edited?

---

<div class="post-metadata">

**Author:** ![Ron.Lor](https://avatars.discourse-cdn.com/v4/letter/r/f17d59/32.png) [@Ron.Lor](https://forum.inductiveautomation.com/u/Ron.Lor)\
**Post date:** [September 9, 2013, 10:32pm UTC](https://forum.inductiveautomation.com/t/table-edit-number-format/7227/2 "2013-09-09T22:32:03Z")

</div>

Are you editing the number in the dataset using the dataset property of the table in the designer? If you are, unfortunately there is no way to change the format of the number when editing.

---

<div class="post-metadata">

**Author:** ![weertske](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/weertske/32/3353_2.png) [@weertske](https://forum.inductiveautomation.com/u/weertske)\
**Post date:** [September 9, 2013, 10:39pm UTC](https://forum.inductiveautomation.com/t/table-edit-number-format/7227/3 "2013-09-09T22:39:03Z")

</div>

I am editing the value within the table (dataset) on a client (or in designer). 😢

---

<div class="post-metadata">

**Author:** ![Robert.McKenzie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/robert.mckenzie/32/4134_2.png) [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\
**Post date:** [September 25, 2013, 10:35pm UTC](https://forum.inductiveautomation.com/t/table-edit-number-format/7227/4 "2013-09-25T22:35:32Z")

</div>

The closest you can get to showing the pretty version of the value is to change the underlying query to format the float as a string. Then in your cellUpdate event, you can change the string back to a float and send that down to the DB.

---

<div class="post-metadata">

**Author:** ![weertske](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/weertske/32/3353_2.png) [@weertske](https://forum.inductiveautomation.com/u/weertske)\
**Post date:** [September 25, 2013, 11:56pm UTC](https://forum.inductiveautomation.com/t/table-edit-number-format/7227/5 "2013-09-25T23:56:24Z")

</div>

Thank you.