How-To Geek on MSN
Formatting Numbers as Percentages in Excel Is Frustrating—But Here's an Easy Fix
This can be frustrating, as there's apparently no easy way to stop this from happening. Until now!Imagine you want to turn all the gradient values in column B in the table below into percentages.
Have you ever opened an Excel file and felt a pang of unease? Rows upon rows of data, cryptic formulas sprawled across cells, and a tangle of manual formatting that seems one misstep away from chaos.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback