# Excel - COLUMN Function Problem - Expert Solution

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

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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.