Formatting a Number in String

[manueurofax]

Hello,
is it possible to set a number in the format: 1 = "001", 2 = "002"?
Thanks for your attention...

[Steve · Accepted solution]

Configure the Number column as above, then use TEXT([Number]) to set the Text column value.

[Steve]

Here:

[manueurofax]

Thanks for your attention...

My problem is that the number must be displayed in that format in a text column...

[Steve · Accepted solution]

Configure the Number column as above, then use TEXT([Number]) to set the Text column value.

[manueurofax]

But will it also work if I put them in a CONCATENATE?

[manueurofax · Accepted solution]

It doesn't work in CONCATENATE(). You have to use a virtual column as suggested and then in CONCATENATE() you find the desired format.

Thanks for your attention...