O'Reilly logo

Microsoft® Office Excel® 2013: Part 1, 2nd Edition by Tim Barnosky

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

Number Format Categories

Excel 2013's number formatting options are arranged by categories, which are grouped according to function, for ease of use. The following table describes the various number formatting categories as displayed on the Number tab in the Format Cells dialog box.
Note: The quick-access number formats that are available from the Number Format drop-down menu are arranged in a slightly different configuration of categories.
Number Format Category Enables You To
General Display numeric data in cells exactly as you enter it. This is the default number formatting in Excel worksheets and, essentially, applies no specific number formatting to your data.
Number Control how many decimal places are displayed, how negative ...

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