Single hash in pivot table data?

[gobblechops]

Hi,

Data pulling through from a table to a pivot table. All numeric codes for 'rows' in the pivot pulling through correctly except one code.

The code is showing a single '#' rather than the actual numeric code? All the numeric codes are formatted in the same way.

Never seen it before, any ideas why and how to correct?

Thanks!

EDIT: Also to add, the pivot table is summing the total values of the numeric code correctly.

 

[GlennUK]

So, for a start, how big is the errant code? Is it larger than the other codes of the list?