Select your cell and go to menu select Edit Clear All (not just hit the
delete key)
It will delete all the format and cell content
type in CD0000

"Raza" wrote:

I'm not sure what you mean, are you saying that I should retype CD0000 in
cell A2? Why would that make a difference? This seems like a systematic
problem in excel.

Anyway, I tried retyping the contents of cell A2 but it didn't work. Any
other ideas?

"Teethless mama" wrote:

Try to retype in row 2

"Raza" wrote:

When I autofilter my database the area selected is rows 2 thru 30,000

cell A2 is CD0000

I filter: greater than CD9999

For some strange reason, everything is filtered out properly except row 2!
What's going on?