Forum Discussion
Muawii
Oct 03, 2022Copper Contributor
FORMULAR
Please how do I write a formular on excel to convert my previous column into a percentage to an adjacent column. such that B4 as 8 can automatically be 80% as C4.
HansVogelaar
Oct 03, 2022MVP
Converting 8 to 80% is unusual, but if you really want that, enter the following formula in C4, and format C4 as a percentage:
=B4/10
But if you want to convert 8 to 8%, use
=B4/100
Muawii
Oct 03, 2022Copper Contributor
thank you