Which of the following MS Excel functions is used to convert a numeric value into a text with a specific format?
-
A.
TEXT()
-
B.
FORMAT()
-
C.
NUMBERTOTEXT()
-
D.
VALUE()
Correct Answer:
A. TEXT()
Explanation:
The TEXT function in Microsoft Excel is specifically designed to convert a numeric value into text while applying a specific format through format codes. While other functions like VALUE perform the opposite action by converting text to numbers, and functions like NUMBERTOTEXT provide basic conversion, only TEXT allows for detailed customization of the output's appearance, such as dates or currency. Because it requires a format mask as its second argument, it is the standard choice for transforming data types for display purposes within a spreadsheet.
Click below to open Discussion & Feedback
0 Issues
Please
login to comment or Report Issues.