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

Options

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

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!