cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
OneNorthJMP
Level V

how to multiple column format at once

When i import numeric percentile data by copy and paste. It automatically trim to 0 decimal. Is that possible i can change all columns at once to 2 decimal point? 

 

OneNorthJMP_0-1576566177487.png

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: how to multiple column format at once

This one is easy. Select all the columns that you want to format. Select Cols > Standardize Attributes. Click Attributes and select Format. Change the Format to the one that you want (Percent). Click OK.

View solution in original post

3 REPLIES 3

Re: how to multiple column format at once

This one is easy. Select all the columns that you want to format. Select Cols > Standardize Attributes. Click Attributes and select Format. Change the Format to the one that you want (Percent). Click OK.

OneNorthJMP
Level V

Re: how to multiple column format at once

Thanks for the great tips!!
gallardet
Level III

Re: how to multiple column format at once

Simple and fast. Thank you very much