Autofilter not capturing all cells

[panther42]

Hi All,

I have a small issue that is getting to me a little on Excel 2003 SP3.
I have a workbook that contains a lot of text on numerous rows (Basically
the text of announcements we use in our telephony department.)
When i use the autofilter function, many of the text boxes do not show up in
the filter. It isn't a number of lines issue as the workbook oly contains
200 lines or so.
I have noticed that if i set the cell formatting to text, the cell just
shows #######################

If i right click on one of the cells in the column, and then select "pick
from drop down list" the text is visible in that drop down list. It just
isn't available in the autofilter drop down.

Ironically, if i select "custom" from the autofilter drop down, and type
contains xxxxxx (xxxxx being a word of phrase from one of the cells that
doesn't show up" then the cell is filter correctly.

Could anyone possibly explain and if so provide me with a workaround?

Thanks

Kevin

 

[Sheeloo]

############## means that cell is formatted as a number or general...
and the value is larger than the cell width.

Increase the column width and test...
What is the number you see if you edit that cell? That should be available
in the drop down...

 

[Gord Dibben]

The cell showing ############## can mean mean one of several things.

A negative date or time, or the column width is too narrow to show the value
if a date or number.

Or..........Excel has a problem with cells containing between 255 and 1024
characters when formatted as Text

Format to General and see what happens.


Gord Dibben MS Excel MVP