- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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?
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: how to multiple column format at once
Thanks for the great tips!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: how to multiple column format at once
Simple and fast. Thank you very much