<div>
yep, that's all I see, when I look around out there...<br />
ok, thanks for your help
</div>


yep, that's all I see, when I look around out there...
ok, thanks for your help

<div>
Yep, sorry about that. You can do it by setting a static table with formulas, but pivottables do have their limitations. <br />
<br />
Thomas
</div>


Yep, sorry about that. You can do it by setting a static table with formulas, but pivottables do have their limitations.

Thomas

<div>
<div class="content wysiwyg-content">
Hello - I've got a Excel 2010 pivot table that displays several percentage amounts (displayed as numbers with 2 decimal places, not with &quot;%&quot; signs), and in the middle of that, the user wants to display 2 particular percentages as a ratio, with a colon separator, like: &quot;1.23 : 4.56&quot;<br />
<br />
I've tried a calculated field, but the pivot table still mashes it into a number.<br />
<br />
Any way to get this done?<br />
<br />
Thanks
</div>
</div>


Hello - I've got a Excel 2010 pivot table that displays several percentage amounts (displayed as numbers with 2 decimal places, not with "%" signs), and in the middle of that, the user wants to display 2 particular percentages as a ratio, with a colon separator, like: "1.23 : 4.56"

I've tried a calculated field, but the pivot table still mashes it into a number.

Any way to get this done?

Thanks

How to get text field to display correctly in pivot table?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.