Percent showing up in thousands

ejacksonBPT

Hello, why is my 32 showing 3,200% instead of 32%

Jennifer Kurtz

@ejacksonBPT - Ah - got it. You can change your formula to include "/100" - so that you're dividing by 100.

Jennifer Kurtz

Hi! You'll just need to enter the percentage as a decimal - 0.32 :)

hope that helps!

ejacksonBPT

how do i do that automated. the top 3 rows in my screen shot are functions to get those numbers and the bottom 3 rows I just used =( and clicked on the corresponding cell in the top 3 rows and then hit the % button.

Jennifer Kurtz

@ejacksonBPT - Ah - got it. You can change your formula to include "/100" - so that you're dividing by 100.