Now if you wanted to change the appearance of this cell and convert this to $’s (without actually changing the actual value), you can use the custom format feature so that the number is shown as $ 100 and not 100. Similarly you can also change this cell to appear as “You scored 100” while the actual value remains 100.
The only difference is that any extra 0 operators specified in an expression would show on the screen.
If you are just beginning to learn this feature, take a minute to familiarize yourself with it.
Apply a set of formats to a cell and check how it appears.
The format to use in such a case is also specified alongwith.
In the above example, the first expression [Red] part of the expression) then show the cell content in Red color (the [Red] part of the expression).