| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter out Non-Number (i.e. Text) Cells
Hi all,
Greetings, Could you please tell me if it is possible to filter out a range by removing that rows in which the cell value is a text and not number. Say, 1. Autofilter on Range A1 to C10 2. Select Criteria on Column A (Cell A1) to show only those rows which contain numbers. I tried Autofilter but there was no such option (Select only Numbers). Please help. Regards Ashish Sharma |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Some cells contain # and text, some # only - want to sum # (number | Excel Discussion (Misc queries) | |||
| Filter on more than one cells (text) | Excel Worksheet Functions | |||
| Excel Changes Text Cells to Number Cells When Importing XML | Excel Discussion (Misc queries) | |||
| number of cells containing text | Excel Discussion (Misc queries) | |||
| How to set a number number value as text in all cells ? | Excel Worksheet Functions | |||
Threaded Mode
