:"Master the powerful tool for converting table text: Detailed explanation of TEXT function"-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. "Master the powerful tool for converting table text: Detailed explanation of TEXT function"

"Master the powerful tool for converting table text: Detailed explanation of TEXT function"

Author: daogeziyuan • • Table skills • Views 798
Converts a numeric value to text in the specified numeric format. Syntax: TEXT(value,format_text)Value is a numeric value, a formula that calculates to a numeric value, or a reference to a cell that contains a numeric value. Format_text is the number format in text form in the Category box on the Number tab in the Format Cells dialog box. Note: - Format_text cannot contain an asterisk (*). - 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 without affecting the numerical value in it. Use the TEXT function to convert a numeric value into formatted text, without the result being used as a number in calculations. The TEXT function is a very powerful conversion function and is often used in our daily work. It can convert numerical values ​​into text represented in a specified numerical format, that is, convert the numerical format into the desired text. Here we will demonstrate its use: we want to convert 0.1235 into a percentage, and we can select cell (B2). Select Insert function and select TEXT function. We select the cell (A2) to fill in the value position. Fill in ("0.0%") in the numerical format, click OK, and you can see that the data has been converted into percentages. This function can also be used when we want to convert a date into a day of the week. We select cell (B3). Select Insert function and select TEXT function. We select the cell (A3) to fill in the value position, and fill in the numerical format position ("aaaa") to determine what day of the week the date just entered is. Click OK and you will see Monday's results appear. You can also use the TEXT function 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 cell (A4) to fill in the value position, and fill in the value format position ("positive number; negative number; zero;"), which means to determine whether the value just entered is a positive number, a negative number, or zero, and click OK. You can see that the result is a "positive number". 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, select the cell (B5), select the insert function, and select the TEXT function. We select the cell (A5) to fill in the value position, and fill in ("0.000") in the numerical format position, indicating that three decimal places are retained. Click OK and you can see that the value conversion has been completed! The conversion function of the TEXT function is very powerful. It can help us save a lot of time when processing batch data. This function must be mastered! (Please note that the image links in the original article have been omitted because they are not text content. If you need to retain the image links, please let us know.)

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/zhang-wo-qiang-da-de-biao-ge-wen-ben-zhuan-huan-li-qi-TEXT-han-shu-xiang-jie.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu lx~沈绝 Columnist
48 196
single-end

Related Suggestion