cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

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