Updating cell in excel

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.

updating cell in excel-3updating cell in excel-9updating cell in excel-85updating cell in excel-7

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][750] part of the expression) then show the cell content in Red color (the [Red] part of the expression).

Leave a Reply