Remove % sign from an Excel table
Solved
Marge
-
Steph -
Steph -
Hello,
I have multiple Excel sheets where I calculated the percentage using the COUNT function, but every time the % sign appears and it is superfluous since I already wrote (percentage) in the title of my column.
I read in another forum that the solution would be to reset the general format and redo my calculations and multiply them by 100, but that would take way too long! Do you have another solution?
I have multiple Excel sheets where I calculated the percentage using the COUNT function, but every time the % sign appears and it is superfluous since I already wrote (percentage) in the title of my column.
I read in another forum that the solution would be to reset the general format and redo my calculations and multiply them by 100, but that would take way too long! Do you have another solution?
2 réponses
Hello,
The principle is good, but it’s not long to do.
- You put the standard format (it’s quick). So instead of having 50%, 75%, you will have 0.50 or 0.75.
Therefore, you need to multiply by 100.
- You type 100 in an empty cell and copy it.
You select your percentage column and do a special paste choosing Multiplication.
And there you go, you have your result.
m@rina
--
- "On the office forum, questions about office work are asked..."
- "Really???"
The principle is good, but it’s not long to do.
- You put the standard format (it’s quick). So instead of having 50%, 75%, you will have 0.50 or 0.75.
Therefore, you need to multiply by 100.
- You type 100 in an empty cell and copy it.
You select your percentage column and do a special paste choosing Multiplication.
And there you go, you have your result.
m@rina
--
- "On the office forum, questions about office work are asked..."
- "Really???"
Thank you.
It worked! Thank you