Prepend zeros to a column in a table box ?

[#1]

Column Id has values like 7,8,9 etc. I want it to be displayed as 007,008,009. Please show me how to do it.

Thanks.

[#2]

In your Number format, click Number and put 000 in the Format Pattern.

[maxgro]

in tab number

Format Pattern 000

[its_anandrjs · Accepted solution]

For column Id you can write this way also

=Num(Id,'000')

[maxgro]

in script, in chart, but in table box???

[its_anandrjs]

For table box need to add a field in the load script like

Load

Id,

Num(Id,'000') as NumId

..

..

From Location;