How to add leading zeros from a number format to create a text number format

AppSheet AppSheet Q&A
1

I have 1 column (Georeference) and virtual column of (Pole number). I want to set virtual column (Pole number) to a 7 digit text number whereas leading zeros will be expected.

Sample
Georeference: 123456
Polenumber: 0123456

How to set a formula in the virtual column in order a 7 digit with leading zeros will be reflected?

Thanks

2

try

RIGHT("" & (10000000 + [Georeference]), 7)
12 Likes
3

Great! It works!

Thank you so much.

1 Like
4

I loved that solution. Super smart. Thanks

5

finally, works with this formula!

thank you so much

1 Like