In order to format your cells the way you want, select those cells and then choose formatting options on the Home tab of the Ribbon.
There are no Dumb Questions
Q:
Q: So the formulas you write completely ignore the formatting choices you make?
A:
A: Not entirely. Excel does try to figure out how to format your formula’s cells by looking at the arguments in your function. If, for example, you wanted to use the SUM function to add a bunch of numbers that were already formatted as currency, Excel would automatically apply that formatting to the cell where you put your formula.
Q:
Q: What if I wanted to use SUM to add a number that was formatted as currency with a number that didn’t have any formatting?
A:
A: In that case, Excel would have no way of knowing what the calculation meant and would have the formula output display without any formatting.
You are currently reading a PREVIEW of this book.
Get instant access to over
$1 million worth of books and videos.