Ok so i built several excel files getting data for various people. i then decided to merge them into one file rather than have multiple files everywhere...here's my problem. when i built the originals i forgot to use the "$" for one of the of the references. so now when i try merging all the files into one sheet it doesn't get the info because i've got nothing telling it to only go from say row 1 to 500 for each person.

the point with all this is i'm trying to put together a pivot table.. i tried creating it with the files on seperate tabs but excel won't let me do that.

so is there an easy way to add the $ to several thousand cells or do i have to do them 1 by 1?