Zero padding as a column format

[#1]

Hey JMP peps!

Is there a way to use a column format to make an integer value be zero padded?  I know you can make a new formula and use right(:col, 5, "0") to get zero padding but it creates a new column that is a character Data type.  In excel, you can use a format of "00000" to get zero padding up to five digits (to match the right() example above).

Thanks for any ideas!

Steve

[#2 · Accepted solution]

You can use Custom Format

[#3]

Hey @jthi ,

Thanks for the quick reply!  So funny, I didn't realized that was a button!

For anyone else looking at this, you click here to get the formula editor for the format you want to use:

Thanks again!

Steve