• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. Applying Number and Date Formats > Working with Large Numbers

Working with Large Numbers

When you have a worksheet that contains numbers displayed in the millions or thousands, you might want to shrink these numbers down to make them more digestible, while retaining the value of millions. For example, ever notice charts or graphs with numbers displayed in two digits but called out as Numbers displayed as (000)? This can be done by applying the custom code formats shown in Figure 4.7. The original number is shown in millions and the results are created by applying the shown custom codes. Make sure you label the numbers appropriately or they could be misinterpreted.

Figure 4.7. You can display large numbers in simple reduced-digit formats.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint