Hi, it's actually in the cells.

Lets say I have 2 lots of phone numbers:

A1 = 02012345678
A2 = 020123456780000

I want to only show the cells like A2 with '0000' in.

If you look at the above thread I have tried all of that and explained the
problem below.
--
Thanks.

CJSnet

(Remove TEETH to reply by e-mail.)


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Is the '0000' actually in the cells or is it a custom format?

Filtering only operates on what is in the cell, not what it is formatted
to
look like.


Gord Dibben Excel MVP

On Wed, 22 Jun 2005 23:24:02 +0100, "CJSnet"
wrote:

Hi guys, I can't get this working.

When I choose custom, I then specify in the top line 'Contains' and the
value '0000'. This should only show rows that contain 0000, however it
filters out all rows, e.g. nothing appears.

Any ideas how to just show rows that have 0000 in the column I am
customising the filter for?