how to append zero in the front of the data of the feild

[Anonymous]

i have delivery number . And this delivery number sometimes will have 9 digits , 8 digits or 7 digits. But i want the end column data should have as 10 digits with zeros in the front .

For example if i have

1234567--- output:  0001234567

12345678-- output: 0012345678

1234567891--- since it is 10 digits it should not change.

[Clever_Anjos]

NUM(field,'0000000000')

[maxgro]

=num(12345678, '0000000000')

=num(yourfield, '0000000000')

or here

[Anonymous]

when i tried this . I am getting null values. Do you think because the format of the field is in text format.

[Anonymous]

Thank you Massimo. But i am getting null values. Let me attached the QVW file.

[Clever_Anjos]

=right('0000000000'&field,10)

[Anonymous · Accepted solution]

If it is text, try

=num(num#(field),'0000000000')

[Anonymous]

@michael Solomovich Thank you . thanks for your help. And Massimo & Anjos thanks for your fast reply.

[Anonymous]

i have posted another question. Can you please help me with that.

how to display rolling 13 months in the line chart

[Anonymous]

i have posted another question can you please help me with that

how to display rolling 13 months in the line chart