Formula to Pad a value with Zeros

I searched but couldn’t find a function to use with a formula column to pad a value with zeros, but found that the TEXT({Opportunity Open Month},“00”) will appropriately pad a value with zeros (up to 2 values in my example, so “7” becomes “07”).

I actually used this as following in a Formula column:

{Opportunity Open Year} & “-” & TEXT({Opportunity Open Month},“00”) → 2021-03

The above formula allowed me to more easily sort, filter and chart my values. I’m sharing so the next person searching for “pad with zeros” may find an easy solution.

1 Like

Hey PegaChris,

Thanks for sharing your formula with the community!

Feel free to also check out our other resources on formulas as you continue becoming a formula master:

Otherwise our Support Team at is always happy to help as well :slight_smile:

Happy Building!