To use these operators or wild cards to filter numeric data, convert the
data to text as in the following example.
Example
The following example assumes that the numeric data is as follows:
A1: 960632515
A2: 960632516
A3: 960632517
A4: 960632518
A5: 960632519
To convert the data to text, follow these steps:
- Select column B.
- On the Insert menu, click Columns.
- In cell B1 (the first cell of the inserted column), enter the
following formula:
- Select the range B1:B5.
- On the Edit menu, point to Fill, and then click Down.
The new column contains the text representations of the numbers in
column A.
- With the same range selected (B1:B5), click Copy on the Edit menu.
- Select cell A1.
- On the Edit menu, click Paste Special. Select Values and click OK.
- Select column B and click Delete on the Edit menu.
The numeric data that was in column A is in a text format and can be
filtered using text filters.
To convert the data back to a numeric format, see the following article in
the Microsoft Knowledge Base:
75945�
How to convert text to numbers in Excel