How to get Pivot Table to display text in a value column?

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