Which of the following MS Excel functions is used to convert a numeric value into a text with a specific format?
-
A.
VALUE()
-
B.
NUMBERTOTEXT()
-
C.
FORMAT()
-
D.
TEXT()
Correct Answer:
D. TEXT()
Explanation:
The TEXT() function in Microsoft Excel is specifically designed to transform a numerical value into a text string while applying a designated format through format codes. This function is particularly useful for displaying numbers in a more readable way or combining them with other text strings without losing their intended formatting, such as date structures or currency symbols. While other functions like VALUE() convert text back into numbers, TEXT() is the standard tool for formatting numeric data as stylized text.
Click below to open Discussion & Feedback
0 Issues
Please
login to comment or Report Issues.