to make the entry of digits as text , you have to begin the entry with an - sign fill in the blanks - mean blank
Answers
Answered by
0
Answer:
To enter the digits as text you have to begin the entry with an equal mark
Explanation:
TEXT function in MS Excel
The TEXT function is used in MS Excel to alter temperance of a number by applying formatting to it.
It is used for converting numeric to text.
In its simplest form, the TEXT function syntax: =
= TEXT(Value you wish to format, "Format code you want to apply")
Example:
=TEXT(1234.567,"#,##")
#.## will displays number up-to to 2 decimal places that is 1234.57
=TEXT(TODAY(),"MM/DD/YY")
Today’s date in format "MM/DD/YY" such as 12/01/21
Similar questions