Hello from Steved

In Col D: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.

On Sep 19, 5:58 pm, Steved wrote:
Hello from Steved

In Col D: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

you can use auto filter custom to display numbers 9999
--
Alan Jung
Triumph Structures
Chatsworth, CA 91311


"Steved" wrote:

Hello from Steved

In Col D: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.

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

Find Next (or Find All)


Steved wrote:

Hello from Steved

In Col D: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.

--

Dave Peterson

Hello from Steved

I thankyou all.

"Dave Peterson" wrote:

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

Find Next (or Find All)


Steved wrote:

Hello from Steved

In Col D: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.

--

Dave Peterson