Converts a numeric value to text in the specified numeric format.
strong>
Syntax
TEXT(value,format_text)
Value is a numeric value, a formula that evaluates to a numeric value, or a reference to a cell that contains a numeric value.
Format_text is the "Cell Format" dialog box Format the number as text in the Category box on the Number tab.
strong>
Description
■ Format_text cannot contain asterisks (*).
■ Call the "Cells" command through the "Format" menu, and then set the format of the cell on the "Number" tab. This will only change the format of the cell but not
will affect the values in it. Use the TEXT function to convert a numeric value into formatted text, without the result being used as a number in calculations.
TEXT function is a very powerful conversion function, which is often used in our daily work.
It can convert the numerical value into text according to the specified numerical format table, that is, convert the numerical format into Convert to desired text. Here we will demonstrate its use:
■ We want to convert 0.1235 into a percentage, and we can select cell (B2).
Select the insert function and select the TEXT function. We select the cell (A2) to fill in the value.
Fill in ("0.0%") in the numerical format, Click OK to see The data is converted into percentages.
■ When we want to convert the date into the day of the week, we can also use this function.
We select cell (B3). Select the insert function and select the TEXT function.
We select the (A3) cell to fill in the value position, In the numerical format position Fill in ("aaaa") means to determine what day of the week the date just entered is.
Click OK and you will see the results for Monday appear.
■ The TEXT function can also be used to determine whether a value is positive, negative or zero.
We select cell (B4), Select the insert function and select the TEXT function.
We select the (A4) cell to fill in the value position, In the numerical format position Fill in ("positive number; negative number; zero;"),means to determine whether the date just entered is
Positive number, negative number or zero,Click OK, you can see that "positive number" appears in the result ".
■ If we want to change the number of digits in a value, we can also use the TEXT function.
For example, keep 3.1415926 to three decimal places,We select the cell (B5), < /span>Select the insert function and select the TEXT function.
We select the (A5) cell to fill in the value position, In the numerical format position Fill in ("0.000"), which means keeping three decimal places.
Click OK and you can see that the value conversion has been completed!
The conversion function of the TEXT function is very powerful. When processing batch data, can help us save money. A lot of time, this function must be mastered!
评论列表(196条)
测试