How to use Excel Text function

Excel version in which TEXT function can work:

Excel TEXT function will work in Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Starter Excel Mobile Excel for Android phones.

About TEXT function:

The excel TEXT function converts the cell into a text format in a specified format. It is a built in worksheet function. You can use this function as part of a formula in a cell of worksheet.

Syntax for excel TEXT Function:

=TEXT(value, format)


value: the value which is to be converted.

format: the format used to display the result.

Using TEXT function:

Let’s look at some TEXT function example.

Let B2 to B6 are cell references.

Sentence Formula Result
12354.235  =TEXT(B2,”$#,##0.00″)                   $12,354.24
12354.235  =TEXT(B3,0) 12354
12-Dec-17  =TEXT(B4,”$##,##0.00″) $43,081.00
12-Dec-17  =TEXT(B5,”YYYY-MM-DD”) 2017-12-12
12-Dec-17  =TEXT(B6,”MMM, DD, YYYY”) Dec, 12, 2017

Excel Text function


Add a Comment

Your email address will not be published. Required fields are marked *