Formatting a Number in String

AppSheet AppSheet Q&A
1

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

2

Here:

Steve_0-1726599398121.png
Steve_0-1726599398121.png520×533 24.6 KB

1 Like
3

Thanks for your attention…

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

4

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

2 Likes
5

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

6

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…

1 Like