Cannot filter excel column - (SAP Output)

[SupperDuck]

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,

 

[Don]

SupperDuck (I like the name) I would look into how you get the data from
SAP, assume you do not have Essbase ? Sounds like you need to select the
column then do Data/Text to Columns. I would guess SAP is sending you
numbers with space before or after and excel is thinking it is text?