nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

912446_en-US

liliconcom

Zero padding as a column format

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

Data Blending and Cleanup

Windows

Re: Zero padding as a column format

You can use Custom Format

Re: Zero padding as a column format

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: