DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Date
|
|
|
Text string
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -The DATEVALUE function in Excel converts a date in the text format to a serial number that Excel recognizes as a date. So, the formula to convert a text value to date is as simple as =DATEVALUE(A1), where A1 is a cell with a date stored as a text string.
Detailed explanation-2: -Select the cell with the formula, press F2, and then press ENTER. The cell displays the value. In the same cell, click Cells on the Format menu. The cell format category will be Text.
Detailed explanation-3: -Add an apostrophe before the number if there are just 2 or 3 cells in Excel that you wish to convert the numbers to strings from. This will convert the numerical format to text right away. Simply double-click in the cell you want to add the apostrophe to and then type the number.