Excel Function : TEXT

Download now!

Excel Function : TEXT

Category

Text

Description

Formats a number and converts it to text

Microsoft Excel Reference Page

https://support.office.com/en-us/article/TEXT-function-20d5ac4d-7b94-49fd-bb38-93d29371225c

Syntax and Description of the TEXT Excel Function

- Stack Overflow I have a function in excel that looks like this: =if(A5=5,C5,"") Is it possible to change the 5 in A5 to be a variable? I want to make it something like this: =if(A5=VARIABLE,C5,"") Is this possible? A: To make a VARIABLE that can be used in a worksheet cell, use a named range. In the worksheet, select the cell you want to name. Choose Formulas → Name Manager → New.

About TEXT Excel Function

The TEXT function in Excel converts a value to text in a specific number format. The TEXT function is useful for displaying numbers in a specific number of decimal places, or for displaying numbers in a currency format. The TEXT function can also be used to concatenate text strings.