Search criteria please

[Guest]

Hello from Steved

In Col D I have 4 numerals, sometimes by mistake somebody has type in a 5
numeral figure please what would the search criteria be to find the 5
numerals only.

Thankyou.

 

[Aqib Rizvi]

Hello from Steved

In Col D I have 4 numerals, sometimes by mistake somebody has type in a 5
numeral figure please what would the search criteria be to find the 5
numerals only.

Thankyou.

Steve
Select Column D, click Data, Filter, Auto Filter
Then click the drop down box and click custom
In the left drop down box click is greater than, in right colum write

9999 and press enter

Records having more than 4 digits will be shown on screen
when finished, click Data, Filter, Auto Filter again

Aqib Rizvi

 

[Guest]

you can use auto filter custom to display numbers >9999

 

[Dave Peterson]

Select your range
Edit|Find
What: ????? (match entire cell contents)

Find Next (or Find All)

 

[Guest]

Hello from Steved

I thankyou all.

Select your range
Edit|Find
What: ????? (match entire cell contents)

Find Next (or Find All)