How to show numbers in column with proceeding zero .

[AP_10343008]

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 ?

[Rocko · Accepted solution]

Decide if you want to use a number type or a string. the number 0500 has the same value as 500.

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.

[vnamboodheri]

Hello @AP_10343008, 

It looks like you have a response on your topic. If it helped you answer your question please mark the reply as the Accepted Solution. 

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.

Thanks,
Community Moderation Team.