DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To treat a number as a text, we add ____ before number
|
|
‘
|
|
|
*
|
|
|
$
|
|
|
!
|
Explanation:
Detailed explanation-1: -If these are just 2 or 3 cells in Excel where you want to convert numbers to string, benefit from adding an apostrophe before the number. This will instantly change the number format to text. Just double-click in a cell and enter the apostrophe before the numeric value.
Detailed explanation-2: -Re: Add Text Before a Formula All you need is to put the text in double-quotes and join it to the formula using the ampersand operator &.
There is 1 question to complete.