Copper Contributor

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.

2 Replies


Converting 8 to 80% is unusual, but if you really want that, enter the following formula in C4, and format C4 as a percentage:




But if you want to convert 8 to 8%, use



thank you