Forum Discussion
Pivot Table displaying bhjh instead of 0 that is in the table
I have a pivot table that is displaying bhjh under one column, where the source table is showing the actual value of 0. It's not a situation where the field is blank it's actually showing a 0 value...
Hi Todd, https://calculadoradenotas.cl/ right-clicking the cell showing “bhjh” in the pivot table, select "Value Field Settings," then click "Number Format" and ensure it's set to "Number" with zero decimal places—this should display actual numeric values like 0 properly. Also, double-check your source data and ensure there are no text values like “bhjh” mixed into the column, even in hidden rows.