# Format # as Percentage?

**URL:** <https://community.parabola.io/t/format-as-percentage/876>\
**Category:** Ask a question\
**Created:** [July 31, 2020, 4:48pm UTC](https://community.parabola.io/t/format-as-percentage/876 "2020-07-31T16:48:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Christopher\_Jackson](https://avatars.discourse-cdn.com/v4/letter/c/51bf81/32.png) [@Christopher\_Jackson](https://community.parabola.io/u/Christopher_Jackson)\
**Post date:** [July 31, 2020, 4:48pm UTC](https://community.parabola.io/t/format-as-percentage/876/1 "2020-07-31T16:48:12Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![anon36387498](https://avatars.discourse-cdn.com/v4/letter/a/b38774/32.png) [@anon36387498](https://community.parabola.io/u/anon36387498)\
**Post date:** [July 31, 2020, 6:46pm UTC](https://community.parabola.io/t/format-as-percentage/876/2 "2020-07-31T18:46:17Z")

</div>

Hi @Christopher_Jackson,

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

 ![Screen Shot 2020-07-31 at 11.43.12 AM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/1X/e079a0106df17cfdc693a7a7f25270b0d4d5a4f7.png)  
  
  
In the **Insert math column** step, enter the column name inside {}, and multiply by 100:  
 ![Screen Shot 2020-07-31 at 11.32.40 AM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/1X/bab8a29b4ca38dcdfb2e812075c99b48f315b7e7.png)  
  
  
In the **Format numbers** step, select the updated column’s name, and enter the amount of desired decimals:  
 ![Screen Shot 2020-07-31 at 11.34.40 AM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/1X/b374a6de8876b24f927a2fb53c5d9546f797d008.png)  
  
  
In the **Insert column** step, enter the desired new column name inside {}, and place a % after them:  
 ![Screen Shot 2020-07-31 at 11.35.45 AM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/1X/7bf838fdede0559a8c6551549557957d9aa850dc.png)  
  
  
  
Feel free to let me know if you need further clarification or if you have any other questions.

---

<div class="post-metadata">

**Author:** ![anon36387498](https://avatars.discourse-cdn.com/v4/letter/a/b38774/32.png) [@anon36387498](https://community.parabola.io/u/anon36387498)\
**Post date:** [October 27, 2020, 9:07pm UTC](https://community.parabola.io/t/format-as-percentage/876/3 "2020-10-27T21:07:35Z")

</div>

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. 👋

 ![Percents](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/1X/f506bdc56475ac519ee0292de560c694b8d84d95.png)