Odd pivot table occurance

[robertdseals]

Hello,
I have a pivot table (created by someone else) that when the value is 500 it shows a period "." instead of the number 500. Has me stumped!

 

[robertdseals]

It's only in one column (if a 500 shows up in another field, it doesn't do it). And if I change one of the periods to 500 it changes them all. But, won't let me change it to something like 400.

 

[RoryA]

Is it a value field, or a row/column/filter field?

 

[robertdseals]

It's a field. (under the "row labels" section of the field list).

 

[RoryA]

In that case, remove it from the pivot table, refresh, then put the field back. That should reset the caption.