Forum Discussion
format multiple columns
is there a way to format multiple columns at once? This picture does not display the full data, but it basically contains dollar columns where I want to insert commas in each one-and ratios, w...
To Format multiple columns you need to go transform/ then highlight set of columns you wnat to change the data format(Percent, Whole number, etc.) then right click and choose Change type. Unfortunately there is no chose from here to select a decimal part but this is something eazy to do from Home tab.
Hope it helps