Common terms in Excel [Format Cells]

User avatar
Site Admin
Posts: 9
Joined: 05 Apr 2020, 03:06
Location: PTP Nagar, Trivandrum

Common terms in Excel [Format Cells]

Postby Administrator 09 Apr 2020, 15:42

Format Cells

When we format cells in Excel, we change the appearance of a number without changing the number itself. We can apply a number format (0.8, $0.80, 80%, etc) or other formatting (alignment, font, border, etc).

1. Enter the value 0.8 into cell B2.
general-format.png (2.27 KiB) Viewed 585 times

2. Select cell B2.

3. Right click, and then click Format Cells (or press CTRL + 1).
format-cells.png (26.75 KiB) Viewed 585 times

The 'Format Cells' dialog box appears.

4. For example, select Currency.
select-currency.png (7.25 KiB) Viewed 585 times

Note: Excel gives you a life preview of how the number will be formatted (under Sample).
Cell B2 still contains the number 0.8. We only changed the appearance of this number. The most frequently used formatting commands are available on the Home tab.

6. On the Home tab, in the Number group, click the percentage symbol to apply a Percentage format.
percentage-format.png (3.5 KiB) Viewed 585 times

7. On the Home tab, in the Alignment group, center the number.
center-alignment.png (4.38 KiB) Viewed 585 times

8. On the Home tab, in the Font group, add outside borders and change the font color to blue.
borders-font-color.png (3.32 KiB) Viewed 585 times

new-format.png (1.38 KiB) Viewed 585 times

Date and Time Formats
Dates and times in Excel can be displayed in a variety of ways. To apply a Date or Time format, execute the following steps.

1. Select cell A1.
date-time-formats.png (2.59 KiB) Viewed 582 times

2. Right click, and then click Format Cells.

3. In the Category list, select Date, and select a Date format.
format-cells (1).png
format-cells (1).png (8.31 KiB) Viewed 582 times

4. Click OK.
long-date-format.png (2.87 KiB) Viewed 582 times
Note: to apply a Time format, in the Category list, select Time.

5. Dates are stored as numbers in Excel and count the number of days since January 0, 1900. Times are handled internally as numbers between 0 and 1. To clearly see this, change the number format of cell A1, B1 and C1 to General.
general-format (1).png
general-format (1).png (2.56 KiB) Viewed 582 times
Note: apparently, 42544 days after January 0, 1900 is the same as June 23, 2016. 6:00 is represented as 0.25 (quarter through the day).

6. You can enter times as 6:00, but Excel displays this time as 6:00:00 AM in the formula bar. AM is used for times in the night and morning. PM is used for times in the afternoon and evening.
time-format.png (2.82 KiB) Viewed 582 times
Note: cell C1 still contains the number 42544.25. We only changed the appearance of the number, not the number itself.

8. Finally, if you cannot find the right date or time format, create a custom date or time format.

Currency vs Accounting
The Currency format and the Accounting format in Excel are very similar to each other. This example shows the difference.

1. Enter the following values.
general-format (2).png
general-format (2).png (2.53 KiB) Viewed 582 times

2. The Currency format places the dollar sign right next to the number.
currency-format.png (2.82 KiB) Viewed 582 times

3. The Accounting format aligns the dollar signs at the left edge of the cell and displays a dash for zero values.
accounting-format.png (2.8 KiB) Viewed 582 times
Note: the Currency format can display negative numbers with a minus sign, in red, with parentheses, or in red with parentheses. The Accounting format displays negative numbers in parentheses.
Thanks & Regards
Saran BL

Was This Topic Useful?

Last 10 Members Who Visited This Topic

MollyMub, Ellentat, User avatar Administrator

Return to “Basic Excel Training”

Who is online

Users browsing this forum: Bing [Bot] and 1 guest