Excel2010 functions: What the text function does and how to use it

Time: 2022-04-27Source: Huajun Informationauthor:


	A brief introduction to the tetext function





TEXT





Converts a numeric value to text in the specified numeric format.





	grammar





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 number format in text form in the Category box on the Number tab in the Format Cells dialog box.





	illustrate





Format_text cannot contain an asterisk (*). Calling the "Cells" command through the "Format" menu, and then formatting the cells on the "Number" tab will only change the format of the cells without affecting the values ​​in them. Use the TEXT function to convert a numeric value into formatted text, without the result being used as a number in calculations.





How to use





1. First create a new blank table and rename it "Calculate the length of time between two dates".





	Excel2010





Excel2010





2. Open the form and enter the corresponding category title, such as "name, business trip time, return time, business trip duration".





	Excel2010





Excel2010





3. Fill in the corresponding content in the "name, business trip time, return time" category.   





	Excel2010





Excel2010





4. Enter the formula "=TEXT(C3-B3,"[h]:mm:ss")" in cell "D3", and the time difference will be displayed.





	Excel2010





Excel2010





5. Select cell "D3". When the cursor changes to a "cross" shape, drag down to copy.





	Excel2010





Excel2010





6. Function description: Subtract the business trip time from the return time to get the length of two different times. Use the TEXT function to set the time display format; where h represents hours, m represents minutes, and s represents seconds.





	Excel2010





Excel2010





The above is what the editor has shared with you about the role and usage of the text function in Excel2010 functions. I hope everyone can apply what they have learned! For more exciting tutorials, remember to follow Huajun Software Park!

Related articles更多>>

Popular recommendations