USE THE T FUNCTION TO CHECK FOR VALID NUMBERS USING MICROSOFT EXCEL

How to check whether a cell contains a number or text in Microsoft Excel? Take a look at Figure 3-29. Notice that some numbers are listed, but there are also references to text and other values. You can check whether a number is a real value in an Excel worksheet by using the T() function in Microsoft Excel. This function checks whether a value is text. If it is text, T returns the text; if it is not, T returns empty text. 

To check for valid numbers:

1. Enter some values in column A and change the format for some of them to text (using the Cells option from the Format menu).

2. Select cells B2:B10 and type the following formula: =T(A2).
3. Press <-Ctrl+Enter->.

USE THE T FUNCTION TO CHECK FOR VALID NUMBERS USING MICROSOFT EXCEL