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

Hour 9. Changing the Look of Values > Designing Custom Numeric Formats

Designing Custom Numeric Formats

In addition to using Excel's preformatted number format settings, you can create your own formats. Here's how it goes: Choose the Custom category on the Number tab in the Format Cells dialog box. You'll see format codes in the Type list on the right. Choose one of the codes as a starting point for the custom format you want to design. Then make your changes to the existing code you selected.

The next To Do exercise gives you a chance to create a custom numeric format. Using the Summary sheet in the Sales workbook, create a custom format that displays a dollar sign followed by one space with commas and zero decimal places.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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