Pages

Sunday, October 30, 2011

Use the T function to check for valid numbers - Text Functions - Microsoft Excel Tutorials


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. 

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->.



Watch the Video Tutorial - https://www.youtube.com/watch?v=FixtOLGNpx8

 

No comments:

Post a Comment

Submit Site to Google Free Articles Search Engine Submission - AddMe Directories Suggest Link Business Directory AutoBackLinks Directory Bingo Bahia Submission Software Reviews