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. I've tried refreshing the table and changing the options to no avail.
Pivot Table
Source Table
7 Replies
This is also a possibility:
No, that's not it. For starters the column is not empty, it actually has a 0 in it for value. Plus I did try populating that with 0 for empty cells and it still would not change.
Thanks for the suggestion
I've seen a similar anomaly before where the value placed in the pivot was a single comma. All settings were good. Ultimately, it was resolved by re-creating the pivot table.
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.
Check the number format of the column that displays bhjh.
Checked the format of both the source table column and pivot table column. Both are fine.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.
