Back to Blog
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. For example, suppose you have a figure, say 100, present in a particular cell of a column which stores the daily sales for a product. Using this feature will retain the underlying data but will change its appearance on the screen. The only change is of how the value appears to the user on the screen.Ī custom format can be applied to a particular cell or a group of cell. Before we get into the details, it is important to remember that when you format a cell using this feature, it does not change the value present in the cell. The custom format feature in Excel allows the user to “paint” or mask a number, text, date or time value in a user defined custom format.
0 Comments
Read More
Leave a Reply. |