Format # as Percentage?

[Christopher_Jackson]

Am I just blind, or is there no option with any of the available tools to format a number as a percentage? I feel like I have to be missing something, but I cannot for the life of me figure it out.

[Adeline]

Hi @Christopher_Jackson,

There is a way, though it is a bit hidden right now. Three steps format number values as percentages:

In the Insert math column step, enter the column name inside {}, and multiply by 100:

In the Format numbers step, select the updated column’s name, and enter the amount of desired decimals:

In the Insert column step, enter the desired new column name inside {}, and place a % after them:

Feel free to let me know if you need further clarification or if you have any other questions.

[Adeline]

Hi all, updating this thread with the news that our step Format numbers now automatically formats numbers as percentages! You’ll no longer need to do a 3-step process to achieve this result.