parentheses for negatives

[Gino Suarez]

Hi ,
How could i set parentheses for negatives using boundcolumns without currency symbol something like this

(1,980.70)

actually i have this dataformatstring , and its cool 'cause completes the decimal position with #.00 always

<telerik:GridBoundColumn    DataField="Noviembre" Aggregate="Sum" HeaderStyle-HorizontalAlign="Right" DataFormatString="{0:N2}" DataType="System.Decimal"
                                                                            FooterAggregateFormatString="{0:N2}" FooterStyle-Font-Bold="true">
                                                                             <HeaderStyle HorizontalAlign="Right" />
                                                                             <ItemStyle HorizontalAlign="Right" />
                                                                     <FooterStyle HorizontalAlign="Right" />
                                                </telerik:GridBoundColumn>

wih this code and setting the dataformatstring={"0:C"} parentheses works but whit the currency symbol

CultureInfo ci = new CultureInfo("es-PE");
ci.NumberFormat.CurrencyNegativePattern = 14;
System.Threading.Thread.CurrentThread.CurrentCulture = ci;

i hope you can help me, thanks

Regards
Gino

[Shinu]

Hi Gino,

You can try the following approach in order to add parentheses if the value is negative.

CS:

    protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
    {
        if (e.Item is GridDataItem)
        {
            GridDataItem dataItem = (GridDataItem)e.Item;
            if (dataItem["Number"].Text != " ")
            {
                if (Convert.ToDouble(dataItem["Number"].Text) < 0)
                {
                    string dbl = dataItem["Number"].Text.ToString();
                    string str = String.Format("({0})", dbl);
                    dataItem["Number"].Text = str;
                }
            }
        }
    }

-Shinu.