# How to format percentages

**URL:** https://community.stackerhq.com/t/how-to-format-percentages/163
**Category:** Tips and Tricks
**Created:** [July 26, 2021, 8:52pm UTC](https://community.stackerhq.com/t/how-to-format-percentages/163 "2021-07-26T20:52:13Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Chelsea\_Scriven](https://dub1.discourse-cdn.com/flex017/user_avatar/community.stackerhq.com/chelsea_scriven/32/156_2.png) [@Chelsea\_Scriven](https://community.stackerhq.com/u/Chelsea_Scriven)
#### Post date: [July 26, 2021, 8:52pm UTC](https://community.stackerhq.com/t/how-to-format-percentages/163/1 "2021-07-26T20:52:13Z")

</div>

At the moment, we do not automatically carry over percentage formatting from Airtable. So you may notice that an Airtable percentage renders in Stacker like this:

![Screen Shot 2021-07-26 at 1.39.42 PM](https://europe1.discourse-cdn.com/flex017/uploads/stacker/original/1X/525fc9e05b39f0157f6b35a61ba1b0f8c07b843b.png)

 ![Screen Shot 2021-07-26 at 1.39.50 PM](https://europe1.discourse-cdn.com/flex017/uploads/stacker/original/1X/b1365b32cf4bbbbeb32b5dc82964dba6e18a1683.png)

To render a form as a percentage, you will need to add a formula field in Airtable that uses the percentage field and renders it in the correct format. You can use the following formula (where ‘Number’ is the name of the field containing the percent):

```auto
Number&"%"

```

For example -  
 ![Screen Shot 2021-07-26 at 1.42.23 PM](https://europe1.discourse-cdn.com/flex017/uploads/stacker/original/1X/7ebd6e7ab65d0c07caca761f17e1d2cd469da9ad.png)

 ![Screen Shot 2021-07-26 at 1.42.35 PM](https://europe1.discourse-cdn.com/flex017/uploads/stacker/original/1X/88e2b347619ce88d01cfa706dae3b46977bd08c8.png)