How to use Excel - Excel Number Format Video - Microsoft Excel Tutorials
16.1 هزار بار بازدید -
11 سال پیش
-
This video explains :-1. Number
This video explains :-
1. Number Formats - Currency, Comma and Percentages
2. How can one copy paste the format of one cell to other
1) We discussed 3 different currency formats -
a) Accounting Format - Sets the number format to the Currency style format and displays left aligned dollar sign in the cell.
b) Comma Format - uses commas to separate
thousands, displays two
decimal places, and encloses
negative values in a closed
pair of parentheses
c) Percent Style - Formats your cell selection using the Percent Style number format, which multiplies the values by 100 and adds a percent sign with no decimal places
2) We noted that Format painter helps to copy paste the format from one cell to another cell
For Free Excel Course Visit: http://www.excel-microsoft-excel.com
For VBA Course go to: http://www.vba-visualbasic.com
For Financial Courses on Financial Modeling, Investment Banking, Equity Research, Accounting Visit: http://www.educorporatebridge.com
1. Number Formats - Currency, Comma and Percentages
2. How can one copy paste the format of one cell to other
1) We discussed 3 different currency formats -
a) Accounting Format - Sets the number format to the Currency style format and displays left aligned dollar sign in the cell.
b) Comma Format - uses commas to separate
thousands, displays two
decimal places, and encloses
negative values in a closed
pair of parentheses
c) Percent Style - Formats your cell selection using the Percent Style number format, which multiplies the values by 100 and adds a percent sign with no decimal places
2) We noted that Format painter helps to copy paste the format from one cell to another cell
For Free Excel Course Visit: http://www.excel-microsoft-excel.com
For VBA Course go to: http://www.vba-visualbasic.com
For Financial Courses on Financial Modeling, Investment Banking, Equity Research, Accounting Visit: http://www.educorporatebridge.com
11 سال پیش
در تاریخ 1392/10/11 منتشر شده
است.
16,149
بـار بازدید شده