cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Use World Cup data to build models, explore spatial relationships, and create informative visualizations in JMP. Register. July 17, 2 pm US Eastern Time.
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
shampton82
Level VII

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

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Zero padding as a column format

You can use Custom Format

jthi_1-1762796541061.png

jthi_0-1762796530654.png

 

-Jarmo

View solution in original post

2 REPLIES 2
jthi
Super User

Re: Zero padding as a column format

You can use Custom Format

jthi_1-1762796541061.png

jthi_0-1762796530654.png

 

-Jarmo
shampton82
Level VII

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:

shampton82_0-1762809742864.png

Thanks again!

Steve

Recommended Articles