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 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...
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!!- Not working for me. I cannot change the data from text to number. Performs counts only.
- No problem, could you mark as answered if that has solved your problem
Thanks
Wyn
