Slicer - How to change number format?

[SunilSangappa]

Hi,

I'm using Excel 2013. I have added a currency column ($1.00, $1.05, $1.10, etc.) to the slicer - which represents the exchange rates that the users are allowed to choose from. The problem is that the items in the slicer revert back to general format (1, 1.05, 1.1, etc.). I would like the items in the slicer window to show up as $1.00 instead of 1. Is there a way to fix this.

Thanks,
Sunil

 

[DILIPandey]

Hi Sunil,

What format is there in the pivot ?


Regards,
DILIPandey

 

[SunilSangappa]

Hi Sunil,

What format is there in the pivot ?


Regards,
DILIPandey

Hi DILIPandey,

The source column (and the Pivot) is in currency format ($1.00, $1.05).

Regards,
Sunil

 

[DILIPandey]

Then there should not be any problem as I tried testing having same setting and did not faced any issue.


Can you post a sample workbook on some public link ?


Regards,
DILIPandey

 

[SunilSangappa]

Thanks for the response. It works if I insert the slicer over a normal pivot table - same as mentioned in your response. But I want to utilise the slicer in a PowerPivot table which means I need to select the option 'Add this data to the Data Model' while I'm inserting the pivot table. And this is where the issue that I was referring to shows up.

Regards,
Sunil