Adding Leading Zeros

Is there anyway to add leading zeros to one of my columns?

Hey Zachary!

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]))

Hi ztrean,

You can try the following formula to have zero-leading N-digitals. N is 3 in the example.

  • Right(Text(1000 + [Number]), 3)