topic Re: Zero padding as a column format in Discussions

Zero padding as a column format

shampton82 — Mon, 10 Nov 2025 17:24:20 GMT

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

Re: Zero padding as a column format

jthi — Mon, 10 Nov 2025 17:42:37 GMT

You can use Custom Format

Re: Zero padding as a column format

shampton82 — Mon, 10 Nov 2025 21:23:31 GMT

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