# Transaction group storing float values in SQL database?

**URL:** <https://forum.inductiveautomation.com/t/transaction-group-storing-float-values-in-sql-database/59021>\
**Category:** Ignition\
**Created:** [April 28, 2022, 8:52pm UTC](https://forum.inductiveautomation.com/t/transaction-group-storing-float-values-in-sql-database/59021 "2022-04-28T20:52:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dcamp1](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\
**Post date:** [April 28, 2022, 8:52pm UTC](https://forum.inductiveautomation.com/t/transaction-group-storing-float-values-in-sql-database/59021/1 "2022-04-28T20:52:11Z")

</div>

Is there a way to format the float value (example 35.6) to be stored in the database as 36.60?

In my report table I don’t find a property to format the cell like #.##/0.00

---

<div class="post-metadata">

**Author:** ![zacht](https://avatars.discourse-cdn.com/v4/letter/z/ea5d25/32.png) [@zacht](https://forum.inductiveautomation.com/u/zacht)\
**Post date:** [April 28, 2022, 9:15pm UTC](https://forum.inductiveautomation.com/t/transaction-group-storing-float-values-in-sql-database/59021/2 "2022-04-28T21:15:43Z")

</div>

There is a property on each cell called `Number Format`. I think that’s what you’re looking for.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/2/3276f06f25487fd43a668f2e5e8c82f3edcac952.png)

---

<div class="post-metadata">

**Author:** ![dcamp1](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\
**Post date:** [April 28, 2022, 9:23pm UTC](https://forum.inductiveautomation.com/t/transaction-group-storing-float-values-in-sql-database/59021/3 "2022-04-28T21:23:54Z")

</div>

Thanks, I don’t know how I missed that? The wife was talking to me.