Excel TEXT function

You are currently viewing Excel TEXT function

Here, we will learn how to use the Excel text function: TEXT.

TEXT function

The Excel TEXT function returns the given number in the given numeric format in the text format. For example, =TEXT(4,"#/#") returns 4/1. TEXT takes the arguments like this: value, format_text, all of which are required. Value accepts the numeric value that needs to be formatted as text. It can be a cell reference or added directly in the formula. Format_text accepts the number formatting code (enclosed in the double-quotes) to apply to the given value. It is usually added directly in the formula.

You have successfully learnt how to use the Excel text function: TEXT.

Download Practice Workbook

Kunal

Hey, I am Kunal Aggarwal, the founder and author of Kunal Excel Tip based in New Delhi, India. I have completed my postgraduation from NIIT Limited, New Delhi in Excel course in 2019. Since then, I have been using and learning Microsoft Excel and started writing posts on the spreadsheet software here since March 2024.

Leave a Reply