# Perspective Table default number format **URL:** \ **Category:** Ignition\ **Tags:** ignition81, perspective\ **Created:** [May 30, 2022, 7:55pm UTC](https://forum.inductiveautomation.com/t/perspective-table-default-number-format/60190 "2022-05-30T19:55:42Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![pgmo](https://avatars.discourse-cdn.com/v4/letter/p/d07c76/32.png) [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Post date:** [May 30, 2022, 7:55pm UTC](https://forum.inductiveautomation.com/t/perspective-table-default-number-format/60190/1 "2022-05-30T19:55:42Z")
Hi all, I use a Perspective table to show the result of a **dynamic** query. That resultset may have different data types at the same column index, depending on which query options the user enables - e.g. column X could be a product name as well as a decimal number representing a quantity. My quantities are as small as 0.xxxE-7, but I cannot use the **columns** prop to format those numbers, because the query is dynamically built. Is there any **default** number format I can set anywhere in the table props, which is then used for any number, wherever it might show up? Thanks in advance, regards ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [May 30, 2022, 8:07pm UTC](https://forum.inductiveautomation.com/t/perspective-table-default-number-format/60190/2 "2022-05-30T20:07:41Z")
Use an expression structure to generate both data and columns props dynamically. ---
**Author:** ![pgmo](https://avatars.discourse-cdn.com/v4/letter/p/d07c76/32.png) [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Post date:** [May 30, 2022, 8:18pm UTC](https://forum.inductiveautomation.com/t/perspective-table-default-number-format/60190/3 "2022-05-30T20:18:15Z")
Thanks pturmel, I was thinking to go that way, but I thought it to be too complicated for my use case.