Hello,
I am using Excel 2007, and I have a problem that I can't resolve after messing about/googling/searching etc. for ages.
I have an excel worksheet that has a mixture of dates/values/text etc all formatted correctly. I then create a name for the range of data in the table and create a pivot table based on that name.
But when I double click to drill down the pivot reults data, the resulting table in the new sheet has all the numbers formatted as Finnish €. I have never used Finnish €, and the base data does not have any Finnish € formatting.
Can anyone help me please?
Thank you in advance
I am using Excel 2007, and I have a problem that I can't resolve after messing about/googling/searching etc. for ages.
I have an excel worksheet that has a mixture of dates/values/text etc all formatted correctly. I then create a name for the range of data in the table and create a pivot table based on that name.
But when I double click to drill down the pivot reults data, the resulting table in the new sheet has all the numbers formatted as Finnish €. I have never used Finnish €, and the base data does not have any Finnish € formatting.
Can anyone help me please?
Thank you in advance
