Buzz
Apart from the basic logical functions in Excel, data formatting in Excel spreadsheets is a crucial aspect. In reality, the usability of Excel data sheets depends heavily on this formatting. Among them, numeric formatting is one of the formats with many useful applications. Here, Mytour will guide you through using number format in Excel.
Guidelines for using the Number Format function
How to Use Number Format Function in Excel
Activating the Format Dialog:
Method 1: To activate the format dialog in the excel spreadsheet, press Ctrl + 1.
Method 2: To format a specific cell, right-click on the target cell and select Format Cell.
Then the Format Cell dialog box appears with the first tab being Number, divided into 3 sections
Section 1: Category of basic formatting types
Section 2: Sample displaying examples of formats
Section 3: Type of detailed formatting options
The Category dialog box displays 12 types of basic formatting
- General: General formatting is the default format in Excel. It can display decimal numbers, integers, or scientific notations.
- Number: Numeric formatting includes various options.
Users can choose the number of decimal places by entering the desired number in the Decimail Places section.
Use commas to separate thousands by selecting the Use 1000 Separator (,) option.
There are also 04 options for displaying negative numbers
- Currency: Currency format
- Accounting: Accounting format, with currency symbols aligned vertically
- Date: Date format allows users to choose different date formats
- Time: Time format allows users to choose different time formats
- Percentage: Percentage format allows users to choose the number of decimal places to display and always includes the “%” sign
- Fraction: Fraction format allows users to choose 1 of 9 ways to represent fractions in the Type section
- Scientific: Scientific format, if you enter the number 5 into this format, it will display as 5.00E+00
- Text: Text format, where all data is displayed as text
- Special: Special format
- Custom: Custom format, for example: to display “04/12/2015” as “ December 04, 2015” we add the following format:
Step 1: Open Excel and enter “04/12/2015”
Step 2: Press Ctrl + 1
Step 3: At the Number tab, select Custom and enter ( 'Date' dd ' month' mm ' year' yyyy ) in the Type section
Step 4: Press OK to see the result as shown in the image
So with the above instructions, you now know how to use Number Format in Excel. To further enhance your understanding of basic computational functions when using Excel, readers can follow articles compiling common computational functions in Excel to make computation tasks more convenient.
