Formula for =text(A1, "000000-0" ?

I am looking for a similar Smartsheet formula that excel has that takes text from a column/cell; say 12345-7, and changes to "0012345-7" - forcing the cell to be in a specific format.

Excel uses "=text(A1, "0000000-0")



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!