Use the T function to check for valid numbers in 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.
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->.
No comments:
Post a Comment