Question description:
This user has given permission to use the problem statement for this
blog.
I have calculated percentages in a column but they are showing for example 1800% instead of 18%. How do I remove the 2 zeros at the end. I tried decreasing zeros and it will not take them away.
Solved by M. J. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
05/02/2018 - 08:53
Hello :)
Excelchat Expert
05/02/2018 - 08:53
Are you able to share your sheet?
User
05/02/2018 - 08:53
Hi there, I trying to put in percentages
User
05/02/2018 - 08:54
It is lising 18% as 1800%
User
05/02/2018 - 08:54
I tried to decrease the zeros but it will not take them away
Excelchat Expert
05/02/2018 - 08:54
One simple solution could be to divide it by 100
Excelchat Expert
05/02/2018 - 08:54
It is taking your percentage as a whole number instead of a percentage.
User
05/02/2018 - 08:56
My formula is =Sum(C4-B4) I am trying to get the difference for two different tests
Excelchat Expert
05/02/2018 - 08:56
Okay, so do this:
Excelchat Expert
05/02/2018 - 08:56
=sum(c4-b4)/100
User
05/02/2018 - 08:56
to get the district average %
User
05/02/2018 - 08:56
okay, thank you I will try that. I really appreciate it.
User
05/02/2018 - 08:57
gave me 0.18
Excelchat Expert
05/02/2018 - 08:57
Yes, that is 18 percent.
User
05/02/2018 - 08:57
how do I show the percent sign for the directors
Excelchat Expert
05/02/2018 - 08:57
Now, if you change the format to percentage.
Excelchat Expert
05/02/2018 - 08:57
by going up to the top and changing it to %
User
05/02/2018 - 08:58
whalaaaaa it worked. Thank you so much!
Excelchat Expert
05/02/2018 - 08:58
You're very welcome :)
Excelchat Expert
05/02/2018 - 08:58
Is there anything else I can help with?
User
05/02/2018 - 08:58
No thank you.
Excelchat Expert
05/02/2018 - 08:59
My pleasure! Please be sure to rate your service after pressing end sesion
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.