Pivot Table changing Numbers

[avikgt]

I have a field in a set of Data with one header as 'Shop ID' which has numbers stored as Text. When I use a Pivot Table on the data - all data under 'Shop ID' shows up as the number itself except for the number '114'. For some reason it shows up as the number '430' on the Pivot Table. Any idea why ?

[alansidman]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

[avikgt]

I recreated the Pivot Table - and the error disappeared.