T

Definition: The T function in Excel is used to convert text to a number.

Syntax: ==T(value).

Situation: This formula is appropriate in situations where you need to convert text to a number.

Example: If you have a text string in cell A1 that says “10”, you would use the formula =T(A1). This would return a value of 10, which is the number represented by the text.