Hi,

In MS 2007 you have multiple filter options and if you trying this in other
version please find below the options which might help u.

On the data menu select Filter.
-click the arrow button of filter and click CUSTOM
-select begins with 12 under SHOW ROWS WHERE
-Say ok.

Hope you find this useful.

Regards,
Uma

"Jugglertwo" wrote:

I would like to filter some different information in my lists but I'm running
into a problem.
I have a column that is our code number at work.
It has 12, 12a, 12b,12c and 1a,1b,1c, etc.
When I filter for the anything that starts with 12 it only gives me the 12.
I would like to get everything that begins with 12 so 12,12a,12b,12c. I have
the same issue with trying to get anything that begins with a 1.
I realized that when a number has a letter with it that it makes it text.
What would I do to solve this so that I could filter as I have stated above?
I tried to format everything to Text but this didn't solve it. I found out
that I could start everyting wiht a single quote and then it would interpret
all entries as text but I really don't want to manually enter the single
quote as I have over 1000 entries that I would need to modify wiht the single
quote.
Any suggestions would be greatly appreciated !
jugglertwo