Forum Discussion
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 ...
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
Hi Michele,
In column AY the zero values are actually entered as "-" rather than just formatted zeros. This will most likely be causing your issue.
You could do a find and replace to replave "-" with 0
- Hi Wyn, thanks for your reply. I know it's a text "-" instead of 0. I left the original extraction. Normally I apply the formula "N" for all the value to convert them into numbers. With find and replace sometimes it takes too much time if there are lots of columns and raws.
This solution allow me to create the pivot table with "sum" for value as default. But still I cannot filter those data...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
- oh come on....was it that simple?!!??
😱 :(
Thanks a lot for your help!!
