Common terms in Excel [Format Cells]

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

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
general-format.png (2.27 KiB) Viewed 584 times

2. Select cell B2.

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

The 'Format Cells' dialog box appears.

4. For example, select Currency.
select-currency.png
select-currency.png (7.25 KiB) Viewed 584 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
percentage-format.png (3.5 KiB) Viewed 584 times

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

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

Result:
new-format.png
new-format.png (1.38 KiB) Viewed 584 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
date-time-formats.png (2.59 KiB) Viewed 581 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 581 times

4. Click OK.
long-date-format.png
long-date-format.png (2.87 KiB) Viewed 581 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 581 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
time-format.png (2.82 KiB) Viewed 581 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 581 times

2. The Currency format places the dollar sign right next to the number.
currency-format.png
currency-format.png (2.82 KiB) Viewed 581 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
accounting-format.png (2.8 KiB) Viewed 581 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

www.i-metrik.com

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: No registered users and 1 guest