•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to get Pivot Table to display text in a value column?
Our take
If you're working with Pivot Tables and encountering issues with Lot codes displaying as zeros instead of their intended text, you're not alone. This common challenge often arises when numeric formats are incorrectly applied to text data. Fortunately, there are settings and techniques to ensure that your Lot codes are displayed correctly. By adjusting the field settings or exploring alternative methods to attach the Lot codes, you can effectively consolidate your company database and enhance your data analysis.
I'm working on a company database and I'm trying to consolidate data into Pivot tables.
Unfortunately, it's reading a column of Lot codes as numbers and displaying them as 0's instead of their Lot codes.
Is there a setting that changes the displayed value for a column from a number to text?
Alternatively, is there another way to display the Lot codes in an attached column?
Thank you in advance.
P.S. For obvious reasons, I can't provide a screenshot, big sorry
[link] [comments]
Read on the original site
Open the publisher's page for the full experience