In my SSRS 2008 R2 report table, I have a text box that contains the following conditional logic for number formatting: =SWITCH ( Fields!Format6.value = "Int", "#,0;(#,0)", Fields!Format6.value = "Percent", "0%", Fields!Format6.Value = "Percent2Decimal","0.00%", Fields!Format6.value = "Decimal","0.00;(0.00)" ) The problem is that if Fields!Format6.value = "Percent2Decimal", the table becomes too wide, and I encounter problems when rendering the report to PDF. The table splits, and the last two columns appear on an additional page. Is there any way that I can hide the "%" symbol when return the number back to the text box as a two decimal percentage? Do I need to consider some other way of controlling the size of the text box when using this format? Thank you for your help. cdun2

If you make a Left() of your cell, using the index of the '.' + 2 as length? I don't have anything to test it right now, but it might work!

I'll try that. Thanks.

I reached an agreement with the client to use one decimal place. I haven't tried using LEFT with this, but I imagine it would only work with strings. I tried to Cstr the cell, but that didn't work.