Forum Discussion

Michele Marco Schiavon's avatar
Michele Marco Schiavon
Copper Contributor
May 22, 2017
Solved

Understand format of a value

Hi,   I get the file attached from an add-in excel program. I'm getting crazy trying to figure it out how the values in the yellow titled column are. Apparently they are in text format, cause when ...
BI & Data Analytics
tips and tricks
  • Wyn Hopkins's avatar
    Wyn Hopkins
    May 23, 2017

    Hi Michelle

     

    You need to click on on a cell in the [.Locationinitiative] column before applying the values filter.  

    That's the most granular level to filter out 0s

     

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
May 22, 2017

Hello Michele

 

Sorry, there is no pivot table in your workbook.

 

Generally you can determin wether a value ist text or number by using ISTEXT() or ISNUMBER().

 

Michele Marco Schiavon's avatar
Michele Marco Schiavon
Copper Contributor
May 23, 2017

Hi Detlef, thanks for your reply. I didn't create the Pivot to send the original file to leave as much info as I could.

 

Anyway, I checked with IS.NUMBER  formula and they are all numbers.

 

Here in this file I created the pivot, after converting all the number with N formula.

 

As you can see...they are number and I can sum them but I cannot apply a filter for the column D E or F.

 

Thanks a lot for your help

 

Ciao