SOLVED

Percentages

Copper Contributor

Hey everyone, my name is Kael and I am new to the community. I am looking for some help converting percentages from raw data in Excel. I keep pressing the percentage button, but I still have a higher percentage point than what I should be getting. For example, a cell contains 50 but when I convert it it goes to 5000%. How do I solve this problem?

2 Replies
best response confirmed by HansVogelaar (MVP)
Solution
If you want to show 50% then type 0.5 and use cell formatting %.

Thank you

1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution
If you want to show 50% then type 0.5 and use cell formatting %.

View solution in original post