DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The formula ( =Text(Value;”DD mmmm YYYY”) the explanation for writing the above formula is . . . . . .
|
|
mmmm means the month and YYYY is the year
|
|
|
mmmm means the year and YYYY is the month
|
|
|
Formulas for Creating Fractional Formats Via the Ribbon
|
|
|
The Formula for Setting the Line (Border)
|
Explanation:
Detailed explanation-1: -First, pick the cells that contain dates, then right-click and select Format Cells. Select Custom in the Number Tab, then type ‘dd-mmm-yyyy’ in the Type text box, then click okay.
Detailed explanation-2: -1. Except the above formula, you can also apply this formula: =TEXT(A2, “mmm") & “-” & TEXT(A2, “yyyy"). 2. In above formulas, A2 indicates the date cell that you want to use, and the separator “-” is used to separate the month and year, you can change it to any other delimiters you need.
There is 1 question to complete.