Well I see a problem. On sheet Jobcost, cells A8 and A9, I cannot use the F2 edit to remove the single quote before the job number, when I remove the single quote, and hit ENTER, the single quote reappears. And when I type over the job (already formatted as text), the single quote gets put back in there by Excel.


Ok I had to retype in rows 8 and 9, make sure the job number was formatted as text (it was) then delete rows 8-9. That's the only way I could get rid of the single quote before those 2 jobs. Then I refreshed the pivot table and it worked.



So a number prefixed with a single quote, is not the same as a number formatted as text.




Thanks for clearing up this data type thing.