Is there anyway to add leading zeros to one of my columns?
Yes you can do this, but the one caveat is that this column will now have to be a string data type for your column. You can use a formula similar to the one below!
Concat( “0”,Text([Number Column]))
You can try the following formula to have zero-leading N-digitals. N is 3 in the example.
- Right(Text(1000 + [Number]), 3)