O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

To Do: Create Your Own Numeric Format

1.
Select the cell that contains the number you want ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required