what excel feature did we use to quickly apply the formatting shown below?

In Excel, you lot can format numbers in cells for things like currency, percentages, decimals, dates, phone numbers, or social security numbers.

1. Select a cell or a cell range.

2. On the Home tab, select Number from the drop-downwardly.
   
   Or, yous tin choose one of these options:

   • Press CTRL + 1 and select Number.

   • Right-click the cell or cell range, select Format Cells… , and select Number.

   • Select the dialog box launcher next to Number and and so select Number.

3. Select the format you want.

Number formats

To come across all available number formats, click the Dialog Box Launcher next to Number on the Home tab in the Number group.

Format	Clarification
General	The default number format that Excel applies when you type a number. For the most part, numbers that are formatted with the Full general format are displayed just the way you lot type them. Nevertheless, if the cell is non wide plenty to show the unabridged number, the Full general format rounds the numbers with decimals. The Full general number format also uses scientific (exponential) annotation for big numbers (12 or more digits).
Number	Used for the general display of numbers. You lot tin specify the number of decimal places that yous want to use, whether you desire to use a thousands separator, and how you want to display negative numbers.
Currency	Used for general monetary values and displays the default currency symbol with numbers. You can specify the number of decimal places that yous want to use, whether you lot desire to use a thousands separator, and how y'all desire to display negative numbers.
Accounting	Likewise used for budgetary values, only it aligns the currency symbols and decimal points of numbers in a cavalcade.
Date	Displays date and time serial numbers as engagement values, according to the type and locale (location) that y'all specify. Engagement formats that brainstorm with an asterisk (*) respond to changes in regional engagement and time settings that are specified in Command Panel. Formats without an asterisk are not affected by Command Panel settings.
Time	Displays engagement and fourth dimension series numbers as time values, according to the type and locale (location) that yous specify. Time formats that begin with an asterisk (*) respond to changes in regional date and time settings that are specified in Command Console. Formats without an asterisk are not affected by Control Panel settings.
Percent	Multiplies the jail cell value by 100 and displays the effect with a percent (%) symbol. You lot can specify the number of decimal places that you desire to use.
Fraction	Displays a number as a fraction, co-ordinate to the type of fraction that you specify.
Scientific	Displays a number in exponential notation, replacing office of the number with E+n, where E (which stands for Exponent) multiplies the preceding number past 10 to the nth ability. For instance, a 2-decimal Scientific format displays 12345678901 every bit 1.23E+10, which is 1.23 times 10 to the 10th ability. You can specify the number of decimal places that you want to use.
Text	Treats the content of a cell as text and displays the content exactly as you type it, even when y'all blazon numbers.
Special	Displays a number as a postal code (Nada Code), phone number, or Social Security number.
Custom	Allows y'all to modify a re-create of an existing number format lawmaking. Use this format to create a custom number format that is added to the list of number format codes. You can add between 200 and 250 custom number formats, depending on the language version of Excel that is installed on your figurer. For more than information about custom formats, see Create or delete a custom number format.

You tin can apply different formats to numbers to change how they appear. The formats just change how the numbers are displayed and don't bear on the values. For example, if you want a number to show as currency, you'd click the cell with the number value > Currency.

Applying a number format only changes how the number is displayed and doesn't touch jail cell values that'southward used to perform calculations. You can see the actual value in the formula bar.

Here's a list of available number formats and how you tin can use them in Excel for the web:

Number format	Description
General	Default number format. If the cell isn't broad enough to show the entire number, this format rounds the number. For example, 25.76 shows as 26. Also, if the number is 12 or more digits, General format displays the value with scientific (exponential) notation.
Number	Works very much like the General format only varies how it shows numbers with decimal place separators and negative numbers. Here are some examples of how both formats display numbers:
Currency	Shows a monetary symbol with numbers. You tin can specify the number of decimal places with Increase Decimal or Decrease Decimal.
Accounting	Also used for budgetary values, but aligns the currency symbols and decimal points of numbers in a cavalcade.
Short Date	Shows engagement in this format:
Long Engagement	Shows month, mean solar day and year in this format:
Fourth dimension	Shows number date and fourth dimension serial numbers every bit time values.
Percentage	Multiplies the prison cell value by 100 and displays the event with a percent (%) symbol. Apply Increment Decimal or Subtract Decimal to specify the number of decimal places you want.
Fraction	Shows the number as a fraction. For example, 0.five displays as ½.
Scientific	Displays numbers in exponential notation, replacing part of the number with E+n, where Eastward (Exponent) multiplies the preceding number past 10 to the nthursday ability. For example, a 2-decimal Scientific format displays 12345678901 equally 1.23E+10, which is ane.23 times 10 to the 10th power. To specify the number of decimal places you want to employ, utilise Increase Decimal or Decrease Decimal.
Text	Treats the cell value as text and displays it exactly as you blazon it, even when y'all type numbers. Larn more than virtually formatting numbers equally text.

tannerincentoll.blogspot.com

Source: https://support.microsoft.com/en-us/office/available-number-formats-in-excel-0afe8f52-97db-41f1-b972-4b46e9f1e8d2

Share this post