Fast Begin: Format numbers in a worksheet

Fast Begin: Format numbers in a worksheet

By making use of completely different quantity codecs, you’ll be able to show numbers as percentages, dates, foreign money, and so forth. For instance, should you’re working in your quarterly funds, you should use the Forex quantity format to point out financial values.

Numbers formatted as currency

Watch the video


Icon image

Choose the cells that you simply need to format.

Selected cells

Icon image

On the House tab, within the Quantity group, click on the dialog field launcher subsequent to Quantity (or simply press CTRL+1).

Dialog Box Launcher in Number group

Icon image

Within the Class listing, click on the format that you simply need to use, after which alter settings, if obligatory. For instance, should you’re utilizing the Forex format, you’ll be able to choose a distinct foreign money image, present extra or fewer decimal locations, or change the way in which damaging numbers are displayed.

Format Cells dialog box

For extra details about quantity codecs, see Out there quantity codecs.

Subsequent steps

  • If Microsoft Excel shows ##### in a cell after you apply quantity formatting to it, the cell in all probability is not vast sufficient to show the info. To develop the column width, double-click the fitting boundary of the column that accommodates the cells with the ##### error. This robotically resizes the column to suit the quantity. You may as well drag the fitting boundary till the columns are the scale that you really want.

  • More often than not, numbers show the way in which you propose them to, whether or not you enter them within the worksheet or import them from a database or different exterior supply. Nonetheless, Excel often applies an surprising quantity format, and you could have to make some changes consequently. For instance, should you kind a quantity that accommodates a slash mark (/) or hyphen (-), Excel might interpret it as a date and convert it to this point format. If you wish to kind non-calculated values akin to 10e5, 1 p, or 1-2, and you don’t want Excel to transform the worth to a built-in quantity format, you’ll be able to apply the Textual content format to the cells, after which enter the quantity.

  • If the built-in quantity format would not meet your wants, you’ll be able to create your personal customized quantity format. For the reason that code used to create the quantity codecs might be tough to grasp at first, it is best to make use of one of many built-in quantity codecs as a place to begin. You’ll be able to then change any one of many code sections of that format to create your personal customized quantity format. To see the quantity format code for a built-in quantity format, click on the Customized class, and look within the Kind field. For instance, the code [<=9999999]###-####;(###) ###-#### is used to show the telephone quantity (555) 555-1234. For extra info, see Create or delete a customized quantity format.

High of Web page

Leave a Reply