Hi,

I am working with a spreadsheet and I'm trying to use the getpivot data
function with dollar amounts. It has worked for all other figures on my
spreadsheet but when I try to get a number that is $$ the function isn't
working I get the REF error.

My formula looks like this: =GETPIVOTDATA("Average Salary",Sheet1!$A$6,"C-R
Band",".85-.89")

Thanks for any help you can offer!

MIM