https://www.ptcusercommunity.com/t5/ThingWorx-Developers/How-to-show-numbers-in-column-with-proceeding-zero/m-p/957781#M66995 <P>Decide if you want to use a number type or a string. the number 0500 has the same value as 500.</P> <P>You could store as a number and convert it to have a leading zero if you need to display it, or you can store it as a string with the leading zero(es), and parse it into a number when you need to make computations.</P> Mon, 24 Jun 2024 13:57:19 GMT Rocko 2024-06-24T13:57:19Z https://www.ptcusercommunity.com/t5/ThingWorx-Developers/How-to-show-numbers-in-column-with-proceeding-zero/m-p/957721#M66994 <P>A datashapes with number datatype fields attached to datatable. Now i want to add value '0500', '0820' instead of '500','820'. How to do that ?</P> Mon, 24 Jun 2024 11:05:12 GMT https://www.ptcusercommunity.com/t5/ThingWorx-Developers/How-to-show-numbers-in-column-with-proceeding-zero/m-p/957721#M66994 AP_10343008 2024-06-24T11:05:12Z https://www.ptcusercommunity.com/t5/ThingWorx-Developers/How-to-show-numbers-in-column-with-proceeding-zero/m-p/957781#M66995 <P>Decide if you want to use a number type or a string. the number 0500 has the same value as 500.</P> <P>You could store as a number and convert it to have a leading zero if you need to display it, or you can store it as a string with the leading zero(es), and parse it into a number when you need to make computations.</P> Mon, 24 Jun 2024 13:57:19 GMT https://www.ptcusercommunity.com/t5/ThingWorx-Developers/How-to-show-numbers-in-column-with-proceeding-zero/m-p/957781#M66995 Rocko 2024-06-24T13:57:19Z https://www.ptcusercommunity.com/t5/ThingWorx-Developers/How-to-show-numbers-in-column-with-proceeding-zero/m-p/958597#M67030 <P>Hello <SPAN style="background: var(--ck-color-mention-background); color: var(--ck-color-mention-text);"><a href="https://www.ptcusercommunity.com/t5/user/viewprofilepage/user-id/589479">@AP_10343008</a></SPAN>,&nbsp;</P> <P>&nbsp;</P> <P>It looks like you have a <A href="https://community.ptc.com/t5/ThingWorx-Developers/How-to-show-numbers-in-column-with-proceeding-zero/m-p/957781#M66995" target="_blank">response</A> on your topic. If it helped you answer your question please mark the reply as the Accepted Solution.&nbsp;<BR /><BR />Of course, if you have more to share on your issue, please let the Community know so other community members can continue to help you.<BR /><BR />Thanks,<BR />Community Moderation Team.</P> Fri, 28 Jun 2024 03:16:50 GMT https://www.ptcusercommunity.com/t5/ThingWorx-Developers/How-to-show-numbers-in-column-with-proceeding-zero/m-p/958597#M67030 vnamboodheri 2024-06-28T03:16:50Z