Forum Discussion
Solved
Convert In-Place, no new column, Decimal to Percentage
Power Query, Is there anyway to convert a number to a percentage without adding a new column? Sample Data: Convert to Percentage 100 50 31 87
You can just adjust the data type, e.g. via the data-type-button in the column header (at the left).
Otherwise, various options on the "Transform" tab adjust data without adding a column.
So if you need to divide the results by 100, go to the Transform tab - Standard - Divide.
You can just adjust the data type, e.g. via the data-type-button in the column header (at the left).
Otherwise, various options on the "Transform" tab adjust data without adding a column.
So if you need to divide the results by 100, go to the Transform tab - Standard - Divide.
First suggestion didn't work but the second did... Thanks Marcel!
