I use these functions to summarize data with formulas instead of dialog boxes. That makes it easier to see exactly what's happening and adjust analysis on the fly. If you're also comfortable with ...
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.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback