Hi

For some strange reason the work sheet columns in my file managed to acquire a format of currency. This happend to any field which was a number or a date. I have reset the sheet columns to the correct format as far as I can see. However if I add a field into the pivot table it will come up in dollars. Also if i double click on the cell in the pivot table to display the data it too will display numbers and dates as dollars. This is so frustrating.

Thank you in advance to anybody who can help.

Mark