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.
Select the cell that contains the number you want ...