Keep getting percentage figures like 6000% (in thousands)?

[JIT_3131]

Hi there
My Google Sheet has formulas like (a1/b2)*100… and the cells are formatted as numbers
On my Apps Sheet I get instead of a figure of 60 (ie. 60%), a figure of 6000%?!
How do I fix this?!
Thanks

[Aleksi · Accepted solution]

Remove the *100. Percentage value should be a decimat value in your gSheet like 0.6

[JIT_3131]

Thank you Aleksi, solved!!!

[Aleksi]

You’re welcome

[Josh_Klassen]

Incase anyone is reading this post.

Here is a related question:

Initial Value Percent Column type Questions

Hi everyone, I am trying to have an initial value in my percent column type of 75. However when I enter 75 it shows as 7,500. I have set the decimal to zero but it still does this. I am not sure where I am going wrong. I also can’t find articles on the type details portion of the percent column type. If anyone knows of any please let me know so I can do some reading. [appsheet%20percent%201] [appshet%20percent%202] [appsheet%20percent%203] Thanks again, Josh