Change Number Format in a Pivot Table

It's easy to change the number format of values in a pivot table. You just click on the field settings and then click on "number format". For some reason this number format box is missing for the row labels in a pivot table.

How do I reformat the row labels data? It seems impossible.

PS - I have long part numbers that I need to format as the direct text they're entered as. The source data is formatted as number, which displays correctly, but the pivot table forces the field to the general format, which comes out as scientific notation. If I highlight the whole column "A" I can select the number format, but there must be a better way through field settings.

Yes, the source data does contain a lot of #N/A. I suspect you're right and this is causing the issue. I don't know any way around it. I could change the #N/A to something else if that helps (maybe 0's). I'd upload the workbook but there's a lot of proprietary info in it.