View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SupperDuck SupperDuck is offline
external usenet poster
 
Posts: 44
Default Cannot filter excel column - (SAP Output)

Hello,

I retvrieve data from SAP and then i have to filter them regarding a column.

The column contains numbers (may be stored as text) . I do;

1. Auto filter
2. column contains, for example 191

When i do this, there is no value! But there are many values that contains
191 in it.

What can be the problem? I try to multiply all values with 1 (write 1 in a
blank cell, copy it, paste special, multiply). Or try to make the values as
text etc.

I do not know what the problem is, but what i know is: I have to filter :)

Thanks & regards,