People who don’t understand custom number formatting will often go through the process of changing their data values rather than just the presentation of those values.įor example, consider a user who wants to show 1,000,000 as 1.0 M. ![]() ![]() Please keep in mind that this is different than conditional formatting which, while allowing you to change the font, font size, text color, and highlighting, does not allow you to change the actual data that appears. It allows you to change the appearance of your data without actually changing the data value The key benefit of custom number formatting is: ![]() ![]() Understanding and mastering this feature can greatly enhance the Visual Design of your Excel workbooks. Because it’s buried deep in the cell formatting menu and has very little documentation, Excel’s custom number formatting is probably its most underutilized feature.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |